Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> EXCEPTION INTO table storage

EXCEPTION INTO table storage

From: <khayter_at_mpi.com>
Date: 9 Aug 2006 14:46:25 -0700
Message-ID: <1155159985.787651.232820@m79g2000cwm.googlegroups.com>


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 Received on Wed Aug 09 2006 - 16:46:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US