Katherine,
As you have observed, ORA-1555 can and will
happen on tables in a read only tablespace.
Tom Kyte covers this well in his book,
Expert Oracle One on One, as well as=20
on the AskTom website. =20
Go to http://asktom.oracle.com/ and do
a search on 'ora 1555 read only tablespace'.
Hope that helps,
-Mark
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of
> KATHERINE_KAYLOR_at_rsausa.com
> Sent: Monday, November 22, 2004 12:19 PM
> To: Oracle-L_at_freelists.org
> Subject: Ora 1555 on a readonly tablespace
>=20
>=20
> I'm trying to CTAS a large table into another database and=20
> it's failing=20
> with 'Snapshot too old'. The source table is located in a readonly=20
> tablespace so I'm certain there are no changes occurring=20
> while the create=20
> table is running and I've used CTAS to copy over smaller=20
> tables from the=20
> databases with no problems. The destination table is created as a=20
> paritioned/subpartitioned table with nologging (or would if=20
> it completed)=20
> and both databases are 9.2.0.5 using AUM.
> I've turned on tracing, but the copy takes a long time to=20
> complete so I=20
> was wondering if anyone had any suggestions as to how this=20
> could happen.
>=20
> Thanks
>=20
> Katherine Kaylor=20
> Royal & SunAlliance
>=20
>=20
>=20
>=20
> **************************************************************
> *********************
> Notice of Confidentiality=20
>=20
> This transmission (including attachments) contains information that=20
> may be privileged, confidential and protected from disclosure. Unless=20
> you are the intended recipient of the message (or authorized=20
> to receive=20
> it for the intended recipient) you may not copy, forward, or=20
> otherwise=20
> use it, or disclose it or its contents to anyone. If you=20
> received this=20
> transmission in error please notify us immediately,=20
> permanently delete=20
> the transmission(including attachments) from your system, and destroy=20
> all hard copies. Thank you.
>=20
>=20
> Email: security_usa_at_rsausa.com
> **************************************************************
> *********************
>=20
>=20
>=20
> --
> http://www.freelists.org/webpage/oracle-l
>=20
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Nov 22 2004 - 12:04:47 CST
