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

Answer / amit goyal

for example


alter database datafile
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\O10G127\SYSTEM01.DBF'
offline for drop;

PCC-00090: Precision/scale specification must be given for DECIMAL datatype

1 Answers  

---

PCB-00207: Invalid use of PIC N or PIC G table variable when NLS_LOCAL=YES

1 Answers  

---

ORA-12419: null binary label value

1 Answers  

---

NNL-00833: Fastest delete processing time: string

1 Answers  

---

ORA-14625: subpartition contains rows corresponding to values being dropped

1 Answers  

---

ORA-06927: CMX: T_DATAIN received before all data written

1 Answers  

---

NNF-01006: Attribute string not available

1 Answers  

---

TNS-00106: Failed to open log file

1 Answers  

---

ORA-13189: recursive SQL parse failed

1 Answers  

---

PLS-00339: "string" matches object-table without a REF or VALUE modifier

1 Answers  

---

ORA-19683: real and backup blocksize of file string are unequal

1 Answers  

---

ORA-13826: empty SQL profile not allowed for create or update SQL profile

1 Answers  

---