The ONLINE keyword makes it simple to compress an existing table online:
alter TABLE scott.emp move new_tablespace row store compress advanced online;
If you omit the new_tablespace clause, Oracle will move it to the same tablespace as it is already residing in and the table will be reorganized and compressed.
No comments:
Post a Comment