ORA-01668: standby database requires DROP option for offline
of data file



ORA-01668: standby database requires DROP option for offline of data file..

Answer / guest

Cause: Attempting to take a datafile offline in a standby
database without specifying the DROP option. Files that are
offline in a standby database are not recovered, and are
likely to be unusable if the standby is activated. Note that
specifying DROP does not prevent bringing the file online later.

Action: Specify the DROP option or leave the file online.

Please add more information about this Error

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

SQL*Loader-00807: error loading table

1 Answers  


ORA-07412: sfaslv: Error getting entry in asynchronous write array.

1 Answers  


PLS-00240: Invalid type specification for RETURN indicator, length, tdo, duration

1 Answers  


NNO-00327: server statistic counter dump ends

1 Answers  


ORA-14513: partitioning column may not be of object datatype

1 Answers  






ORA-22289: cannot perform string operation on an unopened file or LOB

1 Answers   Virtusa,


PCC-02372: FOR clause not allowed in SELECT statement

1 Answers  


ORA-25155: column used in NATURAL join cannot have qualifier

2 Answers  


ORA-00099: timed out while waiting for resource, potential PDML deadlock

1 Answers  


ORA-27067: size of I/O buffer is invalid

1 Answers  


ORA-01326: compatability of 9.0 or greater required to build into the logstream

1 Answers  


SQL*Loader-00293: Missing XMLTYPE directive in control file for table string

1 Answers  


Categories