| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: cannot use system rollback segment for non-system tablespace
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C06AB5.1A2C3FCA
Content-Type: text/plain;
charset="windows-1252"
Hi Siva,
Check how may rollback segments you have online. If you do not have any
rollback segment other than system rollback segment, then you need to create
at least
one non system rollback segment.
Let me knwo if it works.
Adi
-----Original Message-----
From: Sivakumar kalyanasundaram [
Sent: Wednesday, December 20, 2000 11:13 AM
To: Multiple recipients of list ORACLE-L
Subject: cannot use system rollback segment for non-system tablespace
hi all,
whenever executing this statement as below mentioned .. iam getting this type of error.
create table siva as select * from shipref
*
-- 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). ------_=_NextPart_001_01C06AB5.1A2C3FCA Content-Type: text/html; charset="windows-1252" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dwindows-1252"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2448.0"> <TITLE>RE: cannot use system rollback segment for non-system = tablespace</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>Hi Siva,</FONT> </P> <P><FONT SIZE=3D2>Check how may rollback segments you have online. If = you do not have any </FONT> <BR><FONT SIZE=3D2>rollback segment other than system rollback segment, = then you need to create at least </FONT> <BR><FONT SIZE=3D2>one non system rollback segment.</FONT> </P> <P><FONT SIZE=3D2>Let me knwo if it works.</FONT> <BR><FONT SIZE=3D2>Adi</FONT> </P> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Sivakumar kalyanasundaram = [ </FONT> <BR><FONT SIZE=3D2>Sent: Wednesday, December 20, 2000 11:13 AM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: cannot use system rollback segment for = non-system tablespace</FONT> </P> <BR> <P><FONT SIZE=3D2>hi all,</FONT> </P> <P><FONT SIZE=3D2>whenever executing this statement as below = mentioned</FONT> <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 = SIZE=3D2> &nb= sp; &nb= sp; = *</FONT> <BR><FONT SIZE=3D2>ERROR at line 1:</FONT> <BR><FONT SIZE=3D2>ORA-01552: cannot use system rollback segment = for</FONT> <BR><FONT SIZE=3D2>non-system 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> <BR><FONT SIZE=3D2>Do You Yahoo!?</FONT> <BR><FONT SIZE=3D2>Yahoo! Shopping - Thousands of Stores. Millions of = Products.</FONT> <BR><FONT SIZE=3D2><A HREF=3D"http://shopping.yahoo.com/" = TARGET=3D"_blank">http://shopping.yahoo.com/</A></FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Sivakumar kalyanasundaram</FONT> <BR><FONT SIZE=3D2> INET: siva_oracle2000_at_yahoo.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =Received on Wed Dec 20 2000 - 12:46:02 CST
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed = from). You may</FONT> <BR><FONT SIZE=3D2>also send the HELP command for other information =
 |
 |