Hi All. just trying to understand DOMAINS in TDM.
i have a lot of tables which may have the same datatype col in many tables (they actually would have the same name and the same comment too…but domains doesn’t seem to control that).
anyway, as i understand it, if i set them to use a domain (instead of specifying a dataype)…if i were to realize that i had to modify them (say from varchar2(128) to varchar2(256))…they would all be modified at once?
(oh also, defaults and check constraints can be maintained there for the entire domain “group” too).
is that correct?
thanks, David Soniat - University of South Florida.