Disable constraint
Hello,
I want to disable constraint of a particular schema as sys user.
I used
alter table SCOTT.LINKS disable constraint FOREIGN_LINKS_P1 ;
Its giving me error
ERROR at line 1:
ORA-00942: table or view does not exist
select OWNER,CONSTRAINT_NAME,CONSTRAINT_TYPE,TABLE_NAME,STATUS from dba_constraints where OWNER='SCOTT' and TABLE_NAME='LINKS';
OWNER CONSTRAINT_NAME C TABLE_NAME STATUS
------------------------------ ------------------------------ - --- ----------------------- --------
SCOTT FOREIGN_LINKS_P1 P LINKS ENABLED
SCOTT SYS_C00109144 C LINKS DISABLED
SCOTT SYS_C00109154 C LINKS DISABLED
Please suggest solution.
I want to disable constraint of a particular schema as sys user.
I used
alter table SCOTT.LINKS disable constraint FOREIGN_LINKS_P1 ;
Its giving me error
ERROR at line 1:
ORA-00942: table or view does not exist
select OWNER,CONSTRAINT_NAME,CONSTRAINT_TYPE,TABLE_NAME,STATUS from dba_constraints where OWNER='SCOTT' and TABLE_NAME='LINKS';
OWNER CONSTRAINT_NAME C TABLE_NAME STATUS
------------------------------ ------------------------------ - --- ----------------------- --------
SCOTT FOREIGN_LINKS_P1 P LINKS ENABLED
SCOTT SYS_C00109144 C LINKS DISABLED
SCOTT SYS_C00109154 C LINKS DISABLED
Please suggest solution.
0