13 December 2017

ORA-39726: unsupported add/drop column operation on compressed tables

R12.2.0 to R12.2.7 adop failed with ORA-39726

ORA-39726: unsupported add/drop column operation on compressed tables   

select * from dba_tab_partitions where COMPRESSION='ENABLED';

12.1.0.2 Upgrade fails with ORA-39726: unsupported add/drop column operation on compressed tables (Doc ID 2279704.1)

select * from dba_tables where COMPRESSION='ENABLED';   




spool file uncompress_table.sql

SELECT 'alter table '||owner||'.'||TABLE_NAME||' nocompress '||';' sql_to_uncompress_table
FROM   dba_tables where COMPRESSION='ENABLED';

sqlplus apps/apps @uncompress_table.sql

spool file uncompress_partable.sql

SELECT 'alter table '||TABLE_OWNER||'.'||TABLE_NAME||' nocompress '||';' sql_to_uncompress_table
FROM   dba_tab_partitions where COMPRESSION='ENABLED';

sqlplus apps/apps @uncompress_partable.sql

Restart the adop session and check.

 Reference : 12.1.0.2 Upgrade fails with ORA-39726: unsupported add/drop column operation on compressed tables (Doc ID 2279704.1)

No comments: