check the status of the other Rollback segments in the
database. Bring atleast one back online.
- Sivakumar kalyanasundaram
<siva_oracle2000_at_yahoo.com> wrote:
> 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).
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
Received on Wed Dec 20 2000 - 12:38:15 CST