To recover unused space from a table that has never been used but keeps the data intact, which of these options will cause the least impact on application users?
A . Export the table, truncate the table, and import the table.
B . Truncate the table.
C . Drop the table.
D . Export the table, drop the table, and import the table.
E. Deallocate unused blocks.
Explanation:
Answer E: Execute the command ALTER TABLE table_name DEALLOCATE UNUSED. This will deallocate space from the table that is above the high watermark and return it to the free space in the tablespace. There is no impact to the user because the data blocks that have rows in them will not be affected. Each of the other methods mentioned will affect users that need the data.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment