Database Administration (MOSC)

MOSC Banner

Disable constraint

edited Jul 1, 2010 8:56PM in Database Administration (MOSC) 6 commentsAnswered
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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center