Re: ORA-01555
From: Mladen Gogala <no_at_email.here.invalid>
Date: Wed, 13 Oct 2010 22:26:50 +0000 (UTC)
Message-ID: <pan.2010.10.13.22.26.49_at_email.here.invalid>
On Wed, 13 Oct 2010 21:18:37 +0000, Mladen Gogala wrote:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for Linux: Version 10.2.0.5.0 - Production NLSRTL Version 10.2.0.5.0 - Production
Date: Wed, 13 Oct 2010 22:26:50 +0000 (UTC)
Message-ID: <pan.2010.10.13.22.26.49_at_email.here.invalid>
On Wed, 13 Oct 2010 21:18:37 +0000, Mladen Gogala wrote:
> BTW, I am re-running now with the entire tablespace being turned to read
> only. If I get ORA-01555, I will start drinking.
DB is 64bit oracle 10.2.0.5 on RH Linux 5.5
SQL> select * from v$version;
BANNER
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for Linux: Version 10.2.0.5.0 - Production NLSRTL Version 10.2.0.5.0 - Production
Elapsed: 00:00:00.11
-- http://mgogala.byethost5.comReceived on Wed Oct 13 2010 - 17:26:50 CDT