ORA-01245: offline file string will be lost if RESETLOGS is done
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 |
PCC-00090: Precision/scale specification must be given for DECIMAL datatype
PCB-00207: Invalid use of PIC N or PIC G table variable when NLS_LOCAL=YES
ORA-12419: null binary label value
NNL-00833: Fastest delete processing time: string
ORA-14625: subpartition contains rows corresponding to values being dropped
ORA-06927: CMX: T_DATAIN received before all data written
NNF-01006: Attribute string not available
TNS-00106: Failed to open log file
ORA-13189: recursive SQL parse failed
PLS-00339: "string" matches object-table without a REF or VALUE modifier
ORA-19683: real and backup blocksize of file string are unequal
ORA-13826: empty SQL profile not allowed for create or update SQL profile