Thanks for the question, jithesh.
Asked: October 14, 2020 - 8:41 pm UTC
Last updated: October 15, 2020 - 6:29 am UTC
Version: 19c
Viewed 1000+ 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 Connor 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
Is this answer out of date? If it is, please let us know via a Comment