Message-Id: <10565.112627@fatcity.com>
From: Chuck Hamilton <chuck_hamilton@yahoo.com>
Date: Fri, 21 Jul 2000 05:37:47 -0700 (PDT)
Subject: Corrupting rollback segments

--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 <a href="http://mail.yahoo.com/">Yahoo! Mail</a> - Free email you can access from anywhere!
--0-1714636915-964183067=:25131--