unnrecoverable change #
- From: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>, <oracle-db-l@xxxxxxxxxxxxxxxxxxxx>, <ORACLE-L@xxxxxxxxxxxxx>, <oracledba@xxxxxxxxxxx>, <oracle-rdbms@xxxxxxxxxxxxxxx>
- Date: Thu, 17 Nov 2005 08:55:00 -0500
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
Other related posts:
- » unnrecoverable change #
