ORA-01668: standby database requires DROP option for offline
of data file
- 1 Answers
- 4835 Views
- I also Faced
- E-Mail Answers
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 |
SQL-02114: Invalid SQL Cursor usage: trying to CLOSE a CLOSEd cursor
ORA-01274: cannot add datafile 'string' - file could not be created
NNO-00114: line string: other data exists, alias data ignored
SQL-02151: Invalid host variable for exact numeric SET statement item
ORA-38310: cannot purge tablespace for other users
ORA-12990: duplicate option specified
NNL-00981: Timeouts, server not responding: number
ORA-32636: Too many rules in MODEL
KUP-04104: zoned decimal field has bad values for string
TNS-01153: Failed to process string: string
SQL*Loader-00109: Invalid number of logical records to skip
ORA-22933: cannot change object with type or table dependents
Oracle Errors 
