unnrecoverable change #

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Thu, 17 Nov 2005 08:55:00 -0500
Message-Id: <s37c458f.055@gcrta.org>

What does this mean????
SQL> select * from v$datafile where UNRECOVERABLE_CHANGE# <>0; FILE# CREATION_CHANGE# CREATION_ TS# RFILE# STATUS ENABLED
---------- ---------------- --------- ---------- ---------- -------

---

CHECKPOINT_CHANGE# CHECKPOIN UNRECOVERABLE_CHANGE# UNRECOVER LAST_CHANGE#

------------------ --------- --------------------- ---------

---

LAST_TIME OFFLINE_CHANGE# ONLINE_CHANGE# ONLINE_TI BYTES BLOCKS --------- --------------- -------------- --------- ----------

---

CREATE_BYTES BLOCK_SIZE
------------ ----------
NAME

---

PLUGGED_IN BLOCK1_OFFSET
---------- -------------

AUX_NAME

---

6 10519 08-JAN-99 3 6 ONLINE READ WRITE 2809106041 16-NOV-05 867539955 29-NOV-04 700381928 700381929 12-JUN-04 1677721600 204800 0 8192
F:\OR15\AP_INDEX_A.DBS
0 8192
UNKNOWN

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Nov 17 2005 - 09:00:33 CST