alter system set control_files

How To Rename Or Move A Datafile In Oracle

by
How To Rename Or Move A Datafile In Oracle

How To Rename Or Move A Datafile In Oracle: In this article we will see How To Rename Or Move A Datafile In Oracle Database. Here is a sample procedure for relocating a datafile. Assume the following conditions: An open database has a tablespace named users that is made up of datafiles all located on … Read more

Multiplexing Control Files in Oracle

by
Multiplexing Control Files in Oracle

Multiplexing Control Files in Oracle: In this article we will discuss about Multiplexing Control Files in Oracle. This document will detail multiplexing of control files. Having multiple control files reduces the risk of control file loss due to corruption or accidental removal. In the case of corruption or loss recovery is no more difficult than … Read more