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

Oracle 9.2.0.7

On 9 Aug 2006 14:46:25 -0700, khayter (AT) mpi (DOT) com wrote:

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 (AT) andyh (DOT) co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool