Although your table may not be updated during CTAS, has it been updated in the past? You may be encoutering delayed block cleanout. The transactions in the apps schema may have wrapped the rollback segments and any uncleaned transaction slots in your base table may now be pointing to nothing in the rollback segments. Try doing a plain SELECT before CTAS to try to force the block headers to be cleaned up.
- Charlotte
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
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 25 2004 - 05:47:25 CDT
