0
0
SUPPLEMENTAL LOG GROUP "
"
CONSTRAINT "
"
CHECK (
)
(
)
PRIMARY KEY
UNIQUE
FOREIGN KEY (
)
REFERENCES
(
)
NOT NULL
SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS
SUPPLEMENTAL LOG DATA (UNIQUE INDEX) COLUMNS
SUPPLEMENTAL LOG DATA (FOREIGN KEY) COLUMNS
SUPPLEMENTAL LOG DATA (ALL) COLUMNS
DEFERRABLE
INITIALLY DEFERRED
RELY
ALWAYS
0
(
)
USING INDEX (
1
)
USING INDEX
2
NO LOG
,
ON DELETE
CASCADE
SET NULL
SET DEFAULT
DISABLE
VALIDATE
ENABLE
NOVALIDATE
NOVALIDATE
ALTER
DECLARE
CON_NAME VARCHAR2(30);
BEGIN
EXECUTE IMMEDIATE
'SELECT CH.CONSTR_NAME
FROM SYS.KU$_FIND_HIDDEN_CONS_VIEW CH ' ||
'WHERE CH.OWNER_NAME = :1 AND
CH.TABLE_NAME = :2 AND ' ||
'CH.INTCOL_NUM = :3'
INTO CON_NAME
USING '
', '
',
;
EXECUTE IMMEDIATE
'ALTER
' ||
'ENABLE
CONSTRAINT "' || CON_NAME || '" ' ||
'USING INDEX
2
';
END;