RE: Oracle Bug Reports...

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-----
Jared.Still_at_radisys.com
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: Jared.Still_at_radisys.com

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: ListGuru_at_fatcity.com (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: hporas_at_etal.uri.edu

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: ListGuru_at_fatcity.com (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).