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

From: <Babu.Nagarajan_at_Cummins.com>
Date: Wed, 20 Dec 2000 14:35:30 -0500
Message-Id: <10716.125025@fatcity.com>

hi

all your other rollback segments are offline/unavailable. bring them back online.

babu

Sivakumar kalyanasundaram <siva_oracle2000_at_yahoo.com>@fatcity.com on 12/20/2000 11:13:01 AM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:

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

                                   *

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). Received on Wed Dec 20 2000 - 13:35:30 CST