Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01555 error
I seem to recall there is a simple trick to avoiding some single-user
delayed-cleanout footshooting. Something like select count(*) from the
original table before the CTAS, touches all blocks and wakes up the
cleanout. Oh yeah, Metalink Note: 40689.1 and [quoted in]
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:275215756923
explain the situation where this works.
I've kinda wondered why this isn't a stock answer to single user 1555 questions, is the situation so rare?
I certainly prefer to be the only user on the system when I'm doing huge updates or ETL.
Also, check CTAS code to be sure it isn't doing something silly with commits. And is it looking at the table it is creating?
jg
-- @home.com is bogus. http://www.creativearts.com/tiny-trains/gallery.htmReceived on Mon Dec 05 2005 - 16:59:39 CST