Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01245: offline file string will be lost if RESETLOGS is done
- 2 Answers
- 20605 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
Cause: Attempting to do an OPEN RESETLOGS with a file that
will be lost because it is offline. The file was not taken
offline with the FOR DROP option.
Action: Either bring the file online and recover it, or take
it offline with the FOR DROP option.
Please add more information about this Error
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / amit goyal
for example
alter database datafile
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\O10G127\SYSTEM01.DBF'
offline for drop;
| Is This Answer Correct ? | 2 Yes | 3 No |
ORA-29656: Invalid option for USING
QSM-01043: join back attempted on a table to the RHS of a semi or anti join for string
NNO-00063: cannot construct domain checkpoint file name
SQL*Loader-00808: error creating sequence: string
ORA-26036: subpartition load specified but table string is not subpartitioned
PCC-02040: CMD-LINE: Option selected, but no value provided
IMP-00071: Object identifier of imported table mismatches object identifier of existing table
ORA-08278: Cannot get CPU statistics
ORA-19771: cannot rename change tracking file while database is open
ORA-01229: data file string is inconsistent with logs
KUP-04067: internal error allocating handle type string
ORA-30569: data type of given column is not supported in a log group
Oracle Errors 
