Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: cannot use system rollback segment for non-system

RE: cannot use system rollback segment for non-system

From: MacGregor, Ian A. <ian_at_SLAC.Stanford.EDU>
Date: Wed, 20 Dec 2000 12:37:05 -0800
Message-Id: <10716.125031@fatcity.com> 





One no longer has to make a stub rollback segment in the system tablespace
first.



Ian MacGregor


Stanford Linear Accelerator Center


ian_at_slac.stanford.edu



-----Original Message-----


From: William Beilstein [mailto:BeilstWH_at_OBG.com]
Sent: Wednesday, December 20, 2000 10:20 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: cannot use system rollback segment for non-system




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 = (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/ 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Sivakumar kalyanasundaram
  INET: siva_oracle2000_at_yahoo.com 

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
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: William Beilstein
  INET: BeilstWH_at_OBG.com

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 - 14:37:05 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US