Problem with Oracle

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • R.Saminathan
    #1

    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!
    Tags: None
    • 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

        Previous template Next
        Working...