Re: cannot use system rollback segment for non-system

From: William Beilstein <BeilstWH_at_OBG.com>
Date: Wed, 20 Dec 2000 12:54:38 -0500
Message-Id: <10716.125017@fatcity.com>

Thw default rollback segment should only used only for activity against = the SYSTEM tablespace. You have to create a public rollback segment. Due = to fragmentation problems, you should NEVER use the rollback segment in = system for routine activity. Below is the code we use to make our rollback = segments.

create rollback segment r0 storage (initial 24K next 16K maxextents 20) = tablespace system;
alter rollback segment r0 online;
create tablespace rbseg datafile '/u13/oradata/prod/rbseg01PROD.dbf' size = 1900M online;
alter tablespace rbseg add datafile '/u13/oradata/prod/rbseg02PROD.dbf' = size 700 M;
create rollback segment r01 storage (initial 2048K next 4096K maxextents = 249 min
extents 3 optimal 40960K ) tablespace rbseg; alter rollback segment r01 online;
alter rollback segment r0 offline;
create rollback segment r02 storage (initial 2048K next 4096K maxextents = 249 min
extents 3 optimal 40960K ) tablespace rbseg; alter rollback segment r02 online;
create rollback segment r03 storage (initial 2048K next 4096K maxextents = 249 min
extents 3 optimal 40960K ) tablespace rbseg; alter rollback segment r03 online;
create rollback segment r04 storage (initial 2048K next 4096K maxextents = 249 min
extents 3 optimal 40960K ) tablespace rbseg; alter rollback segment r04 online;
create rollback segment r05 storage (initial 2048K next 4096K maxextents = 249 min
extents 3 optimal 40960K ) tablespace rbseg; alter rollback segment r05 online;
create rollback segment r06 storage (initial 2048K next 4096K maxextents = 249 min
extents 3 optimal 40960K ) tablespace rbseg; alter rollback segment r06 online;
create rollback segment r07 storage (initial 2048K next 4096K maxextents = 249 min
 extents 3 optimal 40960K ) tablespace rbseg; alter rollback segment r07 online;
create rollback segment r08 storage (initial 2048K next 4096K maxextents = 249 min
 extents 3 optimal 40960K ) tablespace rbseg; alter rollback segment r08 online;
create rollback segment r09 storage (initial 2048K next 4096K maxextents = 249 min
 extents 3 optimal 40960K ) tablespace rbseg; alter rollback segment r09 online;

Remember to modify your initsid.ora file to automatically bring your new = rollback segments online by inserting the line.

rollback_segments =3D (r01,r02,r03,r04,r05,r06,r07,r08,r09)
>>> Sivakumar kalyanasundaram <siva_oracle2000_at_yahoo.com> 12/20/00 11:13AM =
>>>

hi all,

whenever executing this statement as below mentioned .. iam getting this type of error.

create table siva as select * from shipref

                                   *

ERROR at line 1:
ORA-01552: cannot use system rollback segment for non-system tablespace
'DATA01' with regards,
Siva.

---

Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products. http://shopping.yahoo.com/=20
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20 --=20
Author: Sivakumar kalyanasundaram
  INET: siva_oracle2000_at_yahoo.com=20

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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 Received on Wed Dec 20 2000 - 11:54:38 CST