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@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of > KATHERINE_KAYLOR@xxxxxxxxxx > Sent: Monday, November 22, 2004 12:19 PM > To: Oracle-L@xxxxxxxxxxxxx > 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@xxxxxxxxxx > ************************************************************** > ********************* >=20 >=20 >=20 > -- > //www.freelists.org/webpage/oracle-l >=20 -- //www.freelists.org/webpage/oracle-l