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 could have worked if it was
RENAME FILE
instead of
RENAME DATAFILE
coulda shoulda woulda