Which two statements are correct regarding renaming a tablespace?

Which two statements are correct regarding renaming a tablespace? (Choose two)

Which two statements are correct regarding renaming a tablespace? (Choose two)

A.
You cannot rename a dictionary-managed tablespace.

B.
When you rename a tablespace, all the data files are also renamed accordingly.

C.
You cannot rename a tablespace that happens to be the default permanent tablespace of a user.

D.
You can rename a tablespace provided that COMPATIBILITY initialization parameter is set to at least 10.0.0.0.0.

E.
When you rename a tablespace, the Oracle 10g database updates all references to the tablespace name in the data dictionary as well as the control file.

Explanation:
The COMPATIBLE parameter must be set to 10.0 or higher. When you rename a tablespace the database updates all references to the tablespace name in the data dictionary, control file, and (online) datafile headers. The database does not change the tablespace ID so if this tablespace were, for example, the default tablespace for a user, then the renamed tablespace would show as the default tablespace for the user in the DBA_USERS view.

REF: Oracle 10g Administrator Guide, 8-19



Leave a Reply 1

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


networkmanagers

networkmanagers

I agree with the answer.