DISABLE NOVALIDATE
952526Feb 20 2013 — edited Feb 20 2013Hi, do you know what does first and last DISABLE NOVALIDATE mean ?
seems after I run this script
whole constraint gotr disabled ..........
ALTER TABLE MISPNA.REPLICATE_TABLE_EXTN_DDL ADD (
CHECK ("REPLICATE_TABLE_EXTN_DDL_ID" IS NOT NULL)
DISABLE NOVALIDATE,
CONSTRAINT PK_REMOTE_COPY_DDL
PRIMARY KEY
(REPLICATE_TABLE_EXTN_DDL_ID)
USING INDEX
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 80K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
)
DISABLE NOVALIDATE);