Dropping Control Files - Oracle 10g

You want to drop control files from the database, for example, if the location of a control file is no longer appropriate. Remember that the database should have at least two control files at all times.

  1. Shut down the database.
  2. Edit the CONTROL_FILES parameter in the database initialization parameter file to delete the old control file name.
  3. Restart the database.

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Oracle 10g Topics