Re: Problem with Oracle
From: <sybrandb_at_yahoo.com>
Date: 2 Aug 2004 02:35:40 -0700
Message-ID: <a1d154f4.0408020135.4ce4524e_at_posting.google.com>
Date: 2 Aug 2004 02:35:40 -0700
Message-ID: <a1d154f4.0408020135.4ce4524e_at_posting.google.com>
r.saminathan_at_gmail.com (R.Saminathan) wrote in message news:<c26aa32b.0408012241.56cf11ab_at_posting.google.com>...
> Can anybody help me solve this problem in Oracle:
>
> "ORA-01552: cannot use system rollback segment for non-system tablespace 'PTTBL' "
>
> Thanks!
You'll need to create a second rollback segment in the tablespace
SYSTEM.
After that you can create other tablespaces, create rollback segments
in those tablespaces and put the extrarollback segment in the
tablespace SYSTEM offline.
BTW: did you look up this error on http://tahiti.oracle.com? You would have found this explanation there.
-- Sybrand Bakker Senior Oracle DBAReceived on Mon Aug 02 2004 - 11:35:40 CEST