What must you do before executing it?

Examine the details of the uncompressed, non-partitioned heap table CITIES.

Examine the command:
SQL> ALTER TABLE cities SHRINK SPACE COMPACT;
What must you do before executing it?

Examine the details of the uncompressed, non-partitioned heap table CITIES.

Examine the command:
SQL> ALTER TABLE cities SHRINK SPACE COMPACT;
What must you do before executing it?

A.
Ensure free space that is approximately equal to the space used by the table should be available.

B.
Ensure there are no pending transactions on the table.

C.
Enable row movement is enabled.D. Disable all indexes on the table.



Leave a Reply 2

Your email address will not be published. Required fields are marked *