（214）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 remainas the default but must have no active sort operations.

答案：（A）

解析：

本地管理的临时表空间才支持空间收缩到指定尺寸

ITPub博客

Oracle 11G OCP 1Z0-053 214