Which requirement must be fulfilled for this command to succeed?

You issued the following command on the temporary tablespace LMTEMP in your database:
SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M;
Which requirement must be fulfilled for this command to succeed?

You issued the following command on the temporary tablespace LMTEMP in your database:
SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M;
Which requirement must be fulfilled for this command to succeed?

A.
The tablespace must be locally managed.

B.
The tablespace must have only one temp file.

C.
The tablespace must be made nondefault and offline.

D.
The tablespace can remain as the default but must have no active sort operations.

Show Hint

Leave a Reply 1

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

Magwai

Magwai

http://docs.oracle.com/cd/E11882_01/server.112/e25494/tspaces.htm#ADMIN12353

Shrinking a Locally Managed Temporary Tablespace
Large sort operations performed by the database may result in a temporary tablespace growing and occupying a considerable amount of disk space. After the sort operation completes, the extra space is not released; it is just marked as free and available for reuse. Therefore, a single large sort operation might result in a large amount of allocated temporary space that remains unused after the sort operation is complete. For this reason, the database enables you to shrink locally managed temporary tablespaces and release unused space.

Reply