r.**********@gmail.com (R.Saminathan) wrote in message news:<c2**************************@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 DBA