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