Disable Constraints & Enable Constraints

 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;

How to enable compression on table.

 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.