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 tablespace

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.

  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
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Once again thanx for ur = help.</FONT></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"><B>From:</B>=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"><B>To:</B> <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"><B>Sent:</B> Wednesday, December 20, = 2000 6:45=20
  PM</DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> 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 </FONT><BR><FONT size=3D2>rollback segment other than system = rollback=20
  segment, then you need to create at least </FONT><BR><FONT = size=3D2>one non=20
  system rollback segment.</FONT> </P>
  <P><FONT size=3D2>Let me knwo if it works.</FONT> <BR><FONT = size=3D2>Adi</FONT>=20
  </P>
  <P><FONT size=3D2>-----Original Message-----</FONT> <BR><FONT = size=3D2>From:=20
  Sivakumar kalyanasundaram [&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=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> =
<BR><FONT=20
  size=3D2>Subject: cannot use system rollback segment for non-system=20   tablespace</FONT> </P><BR>
  <P><FONT size=3D2>hi all,</FONT> </P>
  <P><FONT size=3D2>whenever executing this statement as below = mentioned</FONT>=20
  <BR><FONT size=3D2>.. iam getting this type of error.</FONT> </P><BR>   <P><FONT size=3D2>create table siva as select * from shipref</FONT> = <BR><FONT=20
  =
size=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs= p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp= ;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20   *</FONT> <BR><FONT size=3D2>ERROR at line 1:</FONT> <BR><FONT = size=3D2>ORA-01552:=20
  cannot use system rollback segment for</FONT> <BR><FONT = size=3D2>non-system=20
  tablespace</FONT> <BR><FONT size=3D2>'DATA01'</FONT> </P>   <P><FONT size=3D2>with regards,</FONT> <BR><FONT size=3D2>Siva.</FONT> = </P><BR>
  <P><FONT =
size=3D2>__________________________________________________</FONT>=20
  <BR><FONT size=3D2>Do You Yahoo!?</FONT> <BR><FONT size=3D2>Yahoo! = Shopping -=20
  Thousands of Stores. Millions of Products.</FONT> <BR><FONT = size=3D2><A=20
  href=3D"http://shopping.yahoo.com/"=20   target=3D_blank>http://shopping.yahoo.com/</A></FONT> <BR><FONT = size=3D2>--=20
  </FONT><BR><FONT size=3D2>Please see the official ORACLE-L FAQ: <A=20   href=3D"http://www.orafaq.com" =
target=3D_blank>http://www.orafaq.com</A></FONT>=20   <BR><FONT size=3D2>-- </FONT><BR><FONT size=3D2>Author: Sivakumar=20   kalyanasundaram</FONT> <BR><FONT size=3D2>&nbsp; INET:=20   siva_oracle2000_at_yahoo.com</FONT> </P>
  <P><FONT size=3D2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) =

  538-5051&nbsp; FAX: (858) 538-5051</FONT> <BR><FONT size=3D2>San = Diego,=20
  California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public = Internet access=20
  / Mailing Lists</FONT> <BR><FONT=20
  =

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

Original text of this message

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