Skip to Main Content
  • Questions
  • In-database row archival and compression

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, jithesh.

Asked: October 14, 2020 - 8:41 pm UTC

Answered by: Connor McDonald - Last updated: October 15, 2020 - 6:29 am UTC

Category: Database Development - Version: 19c

Viewed 100+ times

You Asked

In Oracle 12c 12.1 version

when a table is compressed, we cannot do a row archival upon that

In Oracle 19c,

if a table is compressed, we can do row archival

,

Why it is so

And what's the method to do indatabase archiving for compressed tables in 12c
And what would be its rolling back scripts. if don't need archiving for a compressed table

and we said...

I need a test case because


SQL> create table t as select * from dba_objects;

Table created.

SQL> alter table t row archival;

Table altered.

SQL> alter table t move compress;

Table altered.

SQL> select banner from v$version where rownum = 1;

BANNER
--------------------------------------------------------------------------------
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production


and

SQL> create table t as select * from dba_objects;

Table created.

SQL> alter table t row archival;

Table altered.

SQL> alter table t move compress;

Table altered.

SQL> select banner from v$version where rownum = 1;

BANNER
------------------------------------------------------------------------------
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production