Re: ORA-1555 on ctas
- From: Charlotte Hammond <charlottejanehammond@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 25 Oct 2004 03:51:57 -0700 (PDT)
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
--
//www.freelists.org/webpage/oracle-l
---------------------------------
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
