How would you perform this?

You need to rename a data file of a tablespace. How would you perform this?

You need to rename a data file of a tablespace. How would you perform this?

A.
make the tablespace that contains the data file read only, rename the data file using the
operating system, execute the ALTERTABLESPACE… RENAME DATAFILE .. statement to
rename the data file, and make the tablespace read/write

B.
bring the database to the NOMOUNT state, rename the data file using the operating
system, and then execute the ALTER TABLESPACE…RENAME DATAFILE .. statement

C.
take the tablespace that contains the data file offline, rename the data file using the
operating system, execute the ALTER DATABASE…RENAME DATAFILE .. statement, and
bring the tablespace online

D.
take the tablespace that contains the data file offline, rename the data file using the
operating system, execute the ALTER TABLESPACE…RENAME DATAFILE .. statement,
and bring the tablespace online



Leave a Reply 4

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


M

M

C & D are the same? Or am I missing something.

M2

M2

C is alter DATABASE and D is alter TABLESPACE. 🙂