Re: how I read SCN directly from data file?

Well... v$database in Oracle8 has the following SCN information avalible:

checkpoint_change# which is the last SCN that was checkpointed.

archive_change# which is the last SCN archived.

in v$datafile you have the following:

checkpoint_change# which is the SCN at the last checkpoint.

unrecoverable_change# which is the last unrecoverable change number made to a datafile.

creation_change# which is the SCN when the datafile was created.

last_change# which is the last change number made to the datafile. This is NULL if the datafile is being changed.

There are a few others, but that should get you started.

This is all contained in the Oracle8 server reference guide. Robert Received on Fri Oct 22 1999 - 07:30:36 CDT