Can anybody help me solve this problem in Oracle:

"ORA-01552: cannot use system rollback segment for non-system tablespace 'PTTBL' "

Thanks!

r.saminathan (AT) gmail (DOT) com (R.Saminathan) wrote in message news:<c26aa32b.0408012241.56cf11ab (AT) posting (DOT) google.com>...

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 DBA