Anuroop Challa

 Disable Constraints & Enable Constraints : =============================== DISABLE: select 'alter table '||owner||'.'||table_name||' disable constraint '||constraint_name||';' from user_constraints; SQL> alter table TABLE_NAME disable constraint CONSTRAINT_NAME; SQL> alter table TABLE_NAME disable constraint CONSTRAINT_NAME cascade; ENABLE: select 'alter table '||owner||'.'||table_name||' enable constraint '||constraint_name||';' from user_constraints; SQL> alter table TABLE_NAME enable constraint CONSTRAINT_NAME;

 Enable compression on table: =================== Basic compression : ALTER TABLE table_name  move COMPRESS ; Advanced compression : alter table table_name move ROW STORE COMPRESS ADVANCED; Please check other posts for compression on partition table.