Re: last SCN?

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Tue, 17 Apr 2001 12:15:49 +0200
Message-ID: <9bh54n$6e6$1@s1.read.news.oleane.net>

"Sven Schäfer" <s.schaefer_at_bmi-heidelberg.com> a écrit dans le message news: newscache$lmkxbg$jk6$1_at_localhost.localdomain...
> Hello,
> is there a view in Oracle that contains the last SCN a file was
> timestamped with?
>
> TIA
>
> Sven
>

v$datafile or v$datafile_header column checkpoint_change#.

--
Have a nice day
Michel

Received on Tue Apr 17 2001 - 05:15:49 CDT

This message: [ Message body ]
Next message: Jared Still: "Re: last SCN?"
Previous message: Sven Schäfer: "last SCN?"
In reply to: Sven Schäfer: "last SCN?"
Next in thread: Jared Still: "Re: last SCN?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US