I am performing a ctas (create table as select ) and receiving the =
infamous Snapshot too old error. I'm not clear as to why because the =
table that I am querying is not being updated. In fact it is read only =
to all apps accounts and the majority of the partitions are in read-only =
tablespaces. My only clue would be dictionary entries. There are a lot =
of small transactions in the database although they are in a separate =
apps schema and do not hit any of these tables. Anyone else run into =
this?
Kenny
=20
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 22 2004 - 14:44:10 CDT
