Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: last SCN?
<posted & mailed>
Sven Schäfer wrote:
> Hello,
> is there a view in Oracle that contains the last SCN a file was
> timestamped with?
select max(ktuxescnw * power(2, 32) + ktuxescnb) from x$ktuxe;
-- Jared Still jkstill_at_cybcon.comReceived on Sun Apr 22 2001 - 15:04:06 CDT