CREATE CONTROLFILE - Cannot potentially damage specified datafiles & redo log files - Oracle Control Files

Q.  The CREATE CONTROLFILE statement can not potentially damage specified datafiles and redo log files.
- Published on 29 Jul 15

a. True
b. False

ANSWER: False
 

    Discussion

  • Nirja Shah   -Posted on 28 Aug 15
    - The true statement is as follows:

    - The CREATE CONTROLFILE statement can potentially damage specified datafiles and redo log files.

    - Omitting a filename can cause loss of the data in that file, or loss of access to the entire database.

    - You can create a new control file for a database using the CREATE CONTROLFILE statement.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)