Corrupting rollback segments

From: Chuck Hamilton <chuck_hamilton_at_yahoo.com>
Date: Fri, 21 Jul 2000 05:37:47 -0700 (PDT)
Message-Id: <10565.112627@fatcity.com>

--0-1714636915-964183067=:25131

Content-Type: text/plain; charset=us-ascii

Yesterday I ran the following PL./SQL code on an 8.1.5 database to recreate all of my rollback segments with the same size parameters. Right after it completed, the database crashed. It wouldn't come up again until I commented out the ROLLBACK_SEGMENTS line of the init.ora file. Can someone tell me why this would have corrupted rollback segments?

begin
  for r in (select segment_name from dba_rollback_segs where segment_name <> 'SYSTEM') loop

    execute immediate 'alter rollback segment '||r.segment_name||' offline';
    execute immediate 'drop rollback segment  '||r.segment_name;
    execute immediate 'create rollback segment '||r.segment_name||' tablespace rbs'
      ||' storage (initial 64k next 64k minextents 20 optimal 1280k)';

    execute immediate 'alter rollback segment '||r.segment_name||' online';   end loop;
end;

---

Do You Yahoo!?
Get Yahoo! Mail - Free email you can access from anywhere!
--0-1714636915-964183067=:25131

Content-Type: text/html; charset=us-ascii

<P>Yesterday I ran the following PL./SQL code on an 8.1.5 database to recreate all of my rollback segments with the same size parameters. Right after it completed, the database crashed. It wouldn't come up again until I commented out the ROLLBACK_SEGMENTS line of the init.ora file. Can someone tell me why this would have corrupted rollback segments?</P> <P>begin<BR>&nbsp; for r in (select segment_name from dba_rollback_segs where segment_name &lt;&gt; 'SYSTEM') loop<BR>&nbsp;&nbsp;&nbsp; execute immediate 'alter rollback segment '||r.segment_name||' offline';<BR>&nbsp;&nbsp;&nbsp; execute immediate 'drop rollback segment&nbsp; '||r.segment_name;<BR>&nbsp;&nbsp;&nbsp; execute immediate 'create rollback segment '||r.segment_name||' tablespace rbs'<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ||' storage (initial 64k next 64k minextents 20 optimal 1280k)';<BR>&nbsp;&nbsp;&nbsp; execute immediate 'alter rollback segment '||r.segment_name||' online';<BR>&nbsp; end loop;<BR>end;<BR></P><BR><BR><p><br><hr size=1><b>Do You Yahoo!?</b><br> Get Yahoo! Mail - Free email you can access from anywhere!
--0-1714636915-964183067=:25131--
Received on Fri Jul 21 2000 - 07:37:47 CDT