Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01245: offline file string will be lost if RESETLOGS is done
- 2 Answers
- 20402 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 |
TNS-00120: Missing PUMPS in INTCHG.ORA
CLSR-01002: Unable to process instance startup
ORA-26515: no master log available for 'string.string'
ORA-19642: incremental-start SCN is string
PCC-02369: An EXEC TOOLS host pointer variable is not a pointer
TNS-01415: Listening Endpoints Summary...
ORA-13415: invalid or out of scope point specification
ORA-02263: need to specify the datatype for this column
KUP-04055: column string is both a field in the data file and a column transform
PLS-00049: bad bind variable 'string'
CLSR-06505: SERVICE_NAMES found null and fixed
ORA-39096: invalid input value string for parameter string
Oracle Errors 
