Re: cannot use system rollback segment for non-system tablespace

From: siva <siva_oracle2000_at_hotmail.com>
Date: Thu, 21 Dec 2000 06:21:46 -0000
Message-Id: <10716.125081@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0036_01C06B16.4BB2DE80 Content-Type: text/plain;

charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

RE: cannot use system rollback segment for non-system tablespacehi Adi = Murugaian,

Thanx a lot for ur findings. worked at last.=20 Once again thanx for ur help.

With regards,
Shiva.

Original Message -----=20 From: Adi Murugaian=20 To: Multiple recipients of list ORACLE-L=20 Sent: Wednesday, December 20, 2000 6:45 PM Subject: RE: cannot use system rollback segment for non-system = tablespace

Hi Siva,=20

  Check how may rollback segments you have online. If you do not have = any=20
  rollback segment other than system rollback segment, then you need to = create at least=20
  one non system rollback segment.=20

Let me knwo if it works.=20
Adi=20

-----Original Message-----=20
From: Sivakumar kalyanasundaram [ =20 Sent: Wednesday, December 20, 2000 11:13 AM=20 To: Multiple recipients of list ORACLE-L=20 Subject: cannot use system rollback segment for non-system tablespace=20

hi all,=20

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

create table siva as select * from shipref=20

                                     *=20

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

  __________________________________________________=20

  Do You Yahoo!?=20
  Yahoo! Shopping - Thousands of Stores. Millions of Products.=20   http://shopping.yahoo.com/=20
--=20

  Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
--=20

  Author: Sivakumar kalyanasundaram=20
    INET: siva_oracle2000_at_yahoo.com=20

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

  --------------------------------------------------------------------=20

To REMOVE yourself from this mailing list, send an E-Mail message=20 to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in=20 the message BODY, include a line containing: UNSUB ORACLE-L=20 (or the name of mailing list you want to be removed from). You may=20 also send the HELP command for other information (like subscribing).=20

------=_NextPart_000_0036_01C06B16.4BB2DE80 Content-Type: text/html;

charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD><TITLE>RE: cannot use system rollback segment for non-system = tablespace</TITLE>
<META content=3D"text/html; charset=3Dwindows-1252" = http-equiv=3DContent-Type>

<META content=3D"MSHTML 5.00.3105.105" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>hi Adi Murugaian,</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanx a lot for ur findings. worked at =

last.=20
</DIV>
<DIV>Once again thanx for ur = help.</DIV>

<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>With regards,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Shiva.</FONT></DIV>
<BLOCKQUOTE=20

style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: = 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px"> <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV> <DIV=20
 style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black">From:=20
 <A href=3D"mailto:adi_at_MarketingAssociates.com"=20 title=3Dadi_at_MarketingAssociates.com>Adi Murugaian</A> </DIV> <DIV style=3D"FONT: 10pt arial">To: <A = href=3D"mailto:ORACLE-L_at_fatcity.com"=20
 title=3DORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L</A> = </DIV>
 <DIV style=3D"FONT: 10pt arial">Sent: Wednesday, December 20, = 2000 6:45=20
 PM</DIV>
 <DIV style=3D"FONT: 10pt arial">Subject: RE: cannot use system = rollback=20
 segment for non-system tablespace</DIV>

  <DIV><BR></DIV>
  <P><FONT size=3D2>Hi Siva,</FONT> </P>
  <P><FONT size=3D2>Check how may rollback segments you have online. If =

you do not=20
 have any rollback segment other than system = rollback=20
 segment, then you need to create at least one non=20
 system rollback segment. 
 Let me knwo if it works. Adi=20
 
 -----Original Message----- From:=20
 Sivakumar kalyanasundaram [      =20

  </FONT><BR><FONT size=3D2>Sent: Wednesday, December 20, 2000 11:13 =
AM</FONT>=20
  <BR><FONT size=3D2>To: Multiple recipients of list ORACLE-L</FONT> =

<FONT=20
 size=3D2>Subject: cannot use system rollback segment for non-system=20 tablespace 
 hi all, 
 whenever executing this statement as below = mentioned=20
 .. iam getting this type of error. create table siva as select * from shipref = <FONT=20
 =
size=3D2>          &nbs= p;           &nbsp= ;           =20 * ERROR at line 1: ORA-01552:=20
 cannot use system rollback segment for non-system=20
 tablespace 'DATA01' with regards, Siva. = 
 <FONT =

size=3D2>__________________________________________________</FONT>=20

Do You Yahoo!? Yahoo! = Shopping -=20
 Thousands of Stores. Millions of Products. <A=20
 href=3D"http://shopping.yahoo.com/"=20 target=3D_blank>http://shopping.yahoo.com/</A> --=20
 Please see the official ORACLE-L FAQ: <A=20 href=3D"http://www.orafaq.com" =
target=3D_blank>http://www.orafaq.com</A>=20 -- Author: Sivakumar=20 kalyanasundaram   INET:=20 siva_oracle2000_at_yahoo.com 
 Fat City Network Services    -- (858) =

538-5051  FAX: (858) 538-5051 San = Diego,=20
 California        -- Public = Internet access=20
 / Mailing Lists <FONT=20
 =

size=3D2>----------------------------------------------------------------=

----=20
 To REMOVE yourself from this mailing list, send an = E-Mail=20
 message to: ListGuru_at_fatcity.com (note EXACT = spelling=20
 of 'ListGuru') and in the message BODY, = include a line=20
 containing: UNSUB ORACLE-L (or the name of = mailing=20
 list you want to be removed from).  You may <FONT = Received on Thu Dec 21 2000 - 00:21:46 CST