V$DATAFILE Columns

Hi,

Following two columns are from v$datafile.
UNRECOVERABLE_CHANGE#,
UNRECOVERABLE_TIME

what these columns specify...

One of my datafile has values

UNRECOVERABLE_CHANGE# - 40280
UNRECOVERABLE_TIME - 16.08.02 13:59:40

and for rest of the datafiles it is NULL

what it means?

Thanks

Sameer

http://otn.oracle.com/docs/products/...40.htm#1089670

Thanks for the prompt reply..

This column is always updated when an unrecoverable operation completes.

but does this mean something has gone wrong with my datafile?

Thanks

Sameer