We got this error on a BLOB.. The database was rebuilt and it went away and everyone breathed a sigh of relief figuring it was a glitch...
Everything works just fine as far as we can tell by the application, but it's back. We got it before we bounced the database and just after it was brought back up again. Database is: Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production With the Partitioning option I found one hit that was a "maybe" but doesn't necessarily seem to be the case at Note: 162345.1. The tablespace has tons of storage. There are not too many errors that can be found with a "" rollback segment name though. They seem large enough, but is there a chance I need one kickbutt rollback or 2-x to export this thing? Just 3 days ago it run just fine... . . exporting table INBOX 88 rows exported . . exporting table INCBLOB 191138 rows exported . . exporting table INDEXTERMS 601879 rows exported Maks. -----Original Message----- You'll probably see that Mohammad and I got this error both before bringing the database down, and after rebooting the server. full export took 11 minutes. -----Original Message----- . . exporting table INCBLOB EXP-00056: ORACLE error 1555 encountered ORA-01555: snapshot too old: rollback segment number with name "" too small ORA-22924: snapshot too old . . exporting table INDEXTERMS 602635 rows exported -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Kline 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).
