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

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

cannot use system rollback segment for non-system tablespace

From: Sivakumar kalyanasundaram <siva_oracle2000_at_yahoo.com>
Date: Tue, 19 Dec 2000 21:12:49 -0800 (PST)
Message-Id: <10716.124984@fatcity.com>


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/ Received on Tue Dec 19 2000 - 23:12:49 CST

Original text of this message

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