Re: Question: SCN too large for archive-log restore

From: DW <dwhittier_at_shaw.ca>
Date: 1 Feb 2005 13:58:39 -0800
Message-ID: <1107295119.782695.311430@o13g2000cwo.googlegroups.com>

Thanks, Andy. Apparently that is a global setting, and will impact all output formatting.

I was also given this one, as a way of assigning the format to a specific alias that won't impact all output.

--

column scn heading 'SCN' format 9999999999999999;

Select min (checkpoint_change#) scn from v$datafile;
--

Cheers,

DW. Received on Tue Feb 01 2005 - 15:58:39 CST