On 9 Aug 2006 14:46:25 -0700, khayter_at_mpi.com wrote:
>Can someone point me to location of where Oracle stores reference table
>for EXCEPTION INTO constraint option.
>
>I have the following contstraint:
>ALTER TABLE MY_Table ADD
> CONSTRAINT MY_Table_UQ UNIQUE (I1)
> DEFERRABLE
> INITIALLY IMMEDIATE ENABLE VALIDATE
> EXCEPTIONS INTO MY_Table_EXCEPTIONS
>
>I was not able to find dependence reference between MY_TABLE and
>MY_TABLE_EXCEPTIONS. I have checked ALL_CONSTRAINTS, ALL_DEPENDENCIES,
>ALL_TABLES
I don't think it's stored; the exception table is only populated once by the
alter table command, it's not populated on an ongoing basis, so a connection
isn't required in the data dictionary.
--
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
Received on Wed Aug 09 2006 - 17:10:43 CDT
