-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|