Multiple choice technology databases

One of the tablespaces is read-only in your database. The loss of all control files forced you to re-create the control file. Which operation do you need to perform after re-creating the control file and opening the database?

  1. drop and re-create the read-only tablespaces

  2. rename the read-only data files to their correct file names

  3. change the tablespace status from read/write to read-only

  4. re-create the read-only tablespace because it is automatically removed

  5. none of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

When you re-create a control file, read-only tablespaces are not automatically added back with their correct file names. You must rename the read-only data files to point to their correct locations to make them accessible.

Keep practicing — related questions