Interesting bug. I'm spacing on one thing though. Don't see where the ORA-1555 is coming from on their test case.
Henry ***EXCERPT FROM BUG REPORT *** *** REM Create the user and the tables in question REM create user medic identified by medic; alter user medic default tablespace users temporary tablespace temp; grant dba to medic; connect medic/medic; create table myobjs1 as select * from dba_objects; create table myobjs2 as select * from dba_objects; create table myobjs3 as select * from dba_objects; declare a number; begin for a in 1..3 loop insert into myobjs1 select * from myobjs1; commit; end loop; end; / REM REM Create small rollback segment to use for these trxs, and offline all REM other non-system rollback segments REM create rollback segment small_rbs_to_use tablespace rbs storage (initial 50k next 50k optimal 200k maxextents unlimited); alter rollback segment small_rbs_to_use online; alter rollback segment <all other non-system rbs here> offline; REM REM Start session 1 REM connect medic/medic set time on update myobjs1 set owner='change1'; commit; REM REM Start session 2 REM connect medic/medic set time on update myobjs1 set owner='change2'; REM REM Start session 3 REM connect medic/medic set time on update myobjs1 set owner='change3'; REM REM Start the Export REM exp medic/medic direct=y tables=\(myobjs1,myobjs2,myobjs3\) log=imp1.log REM You got to be exporting myobjs1 when session 2 and session 3 error out with ORA-1555 (snapshot too old: rollback segment number ...with name "SMALL_RBS_TO_USE" too small). To accomplish this, startup and execute the SQL statement in the three sessions, and see how long it takes, for session 2 to fail with the ORA-1555 after it was submitted for execution. In my test case, it took a minute and 20 seconds before it failed. Therefore I launch the export session a minute and an 10 seconds after executing the SQL in session 2. -----Original Message----- [EMAIL PROTECTED] Sent: Wednesday, March 05, 2003 1:29 PM To: Multiple recipients of list ORACLE-L ... can be rather interesting at times, when there's time to check out a few. http://metalink.oracle.com/metalink/plsql/showDoc?db=BUG&id=2666174 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Henry Poras 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).
