ORA-01552: cannot use system rollback segment for non-system tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-01552: cannot use system rollback segment for non-system tablespace

Hybrid View

  1. #1
    Join Date
    Feb 2009
    Posts
    91

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

    I am trying to create a table in my Oracle 10g database and I get the following error:

    SQL> create table pbh.abc (a number(4), b number(4)) tablespace pbhtables;
    create table pbh.abc (a number(4), b number(4)) tablespace pbhtables
    *
    ERROR at line 1:
    ORA-01552: cannot use system rollback segment for non-system tablespace
    'PBHTABLES'

    When I in run show paramter undo in sqlplus here is my output.


    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    undo_management string AUTO
    undo_retention integer 900
    undo_tablespace string

    This is what I have in my init.ora file.

    Can somebody please tell me what I need to do (include syntax) in order
    to rectify this issue.

    Thanks

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    you havent created an undo tablespace, or if you have you havent set your instance to use it

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width