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.



Leave a Reply 0

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