d:\app\Administrator\product\11.2.0\dbhome_1\RDBMS\admin\utlexcpt.sql
create table exceptions(row_id rowid,
owner varchar2(30),
table_name varchar2(30),
constraint varchar2(30));
if someone disable the constraint and try to enable, it show error exceptions table stores the table and rowid
Alter Table <table_name> Enable constraint <ck_constriantname>
exceptions into exceptions;
No comments:
Post a Comment