Connor and Chris will both be at AI World from October 12 to October 17 , the premier Oracle conference of 2025. If you're in Vegas, please come say Hi or pop into our sessions
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!