Adding Check Constraints on partition table
549855Jul 28 2008 — edited Jul 28 2008Hi,
Oracle Version 8174.
I would to make a table read only for few days , in production database.
I found in asktom site the following option:
alter table XYZ add constraint XYZ_LOCK_CK1 check ( 1=1) disable validate;
Its work fine.
Is it possible to add check constraint on specific partition , in a partition table ?
Running the following statment failed on : ORA-01735 invalid ALTER TABLE option
alter table XYZ.PARTITION_P1006 add constraint P_P1006_LOCK_CK1 check ( 1=1) disable validate;
Thanks