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
C & D are the same? Or am I missing something.
C is alter DATABASE and D is alter TABLESPACE. 🙂
D
Hello,
Confirmed that ans: D
referent url: https://docs.oracle.com/cd/B28359_01/server.111/b28310/dfiles005.htm#ADMIN11431
>>
..
Use the ALTER TABLESPACE statement with the RENAME DATAFILE clause to change the filenames within the databas
..
<<
Thank you
Vin