ORA-1555 on ctas

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

Other related posts: