EXCEPTION INTO table storage

Giganews Newsgroups
Subject: EXCEPTION INTO table storage
Posted by:  khayt…@mpi.com
Date: 9 Aug 2006

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

Replies