Problem with Oracle

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • R.Saminathan

    Problem with Oracle

    Can anybody help me solve this problem in Oracle:

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

    Thanks!
  • sybrandb@yahoo.com

    #2
    Re: Problem with Oracle

    r.saminathan@gm ail.com (R.Saminathan) wrote in message news:<c26aa32b. 0408012241.56cf 11ab@posting.go ogle.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

    Comment

    Working...