QUESTION NO: 415
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.
Answer: A
你在你的数据库的临时表空间LMTEMP上发出以下命令:
修改表空间 lmtemp收缩空间保持20M;
哪个要求必须满足,这个命令才能成功?
A.表空间必须本地管理。