I have a TAR open on this and Im arguing with the Oracle tech support guy.
Here is what happened. We upgraded an instance to 9i. Switched to automatic undo management. Set our undo parameters to point to a newly created undo tablespace. 1. took our old rollback tablespace(with rollback segments in it) offline. 2. I created some new objects. Fine. 3. Then I started creating indexes and doing selects. I would periodically get the following error: ORA-00604: error occurred at recursive SQL level 1 ORA-00376: file 3 cannot be read at this time ORA-01110: data file 3: '<path>/rbs_01.dbf' 4. This is becaus that is the old rollback tablespace that was taken off line and is NOT indicated in the undo parameter as the undo tablespace. 5. Oracle support said the following. 'Most likely what happened is that when you went to create the index it encountered some information in the table in one of the block headers that needed to be retrieved/verified from the rollback segment due to delayed block cleanout. If we see that the rollback segment still exists we try to access it. (It doesn't matter whether we are using auto ot manual at this point.) If we can't access it then we throw an error. If we see that the rollback segment has been dropped then we know for sure that the information in the block header is old because we never drop rollback segments until all active transactions have completed.' 6. Not possible in my opinion. Since the object in question was created AFTER this rollback segment was taken offline. 7. We dropped the old rollback segment and it works fine now. Is this a bug? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).