Re: last_time is always NULL in v$datafile

From: Yong Huang <yong321_at_yahoo.com>
Date: 6 Feb 2002 09:59:07 -0800
Message-ID: <b3cb12d6.0202060959.6ff7ef12@posting.google.com>

Last_change# and last_time are also set to some values when the tablespace is offline or set to read only. In other words, if the datafile is not open for writing, the SCN should be set back to a value from infinite.

Yong Huang
yong321_at_yahoo.com

oraclems_at_hotmail.com (Murali) wrote in message news:<22e6597b.0202060753.5bf67423_at_posting.google.com>...
>
> The last_change# and last_time columns are set to NULL if the datafile
> is being changed (written to). It is expected behavior when the
> database is open. Next time you shut down the database, startup mount
> and query the view. It will show the last change# for the datafile
> that occurred when the database was shut down.
>
> Murali
> http://www.dbaquest.com/
Received on Wed Feb 06 2002 - 11:59:07 CST