The AskTOM team is taking a break over the holiday season, so we're not taking questions or responding to comments. Please have a happy and safe festive season and as always, thanks for being a member of the AskTOM community.
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
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
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
Share and learn SQL and PL/SQL; free access to the latest version of Oracle Database!
Classes, workouts and quizzes on Oracle Database technologies. Expertise through exercise!