creating table give ora-01552....so try to create public rollback also hit ora-1552..

[ngwh]

hi guys,

I have create a test database and it only come with system rollback...so when i try to create a user table on the USER table it gives ORA-01552..so i thot i'll create a rollback tablespace but it give me another ORA-01552...so how am i going to ever create a PUBLIC rollback segment w/o a rollback tablespace to start with? any help ?

thanks in advance.

[zainalj]

create another rollback segment.

[davey23uk]

create a rollback segment in the system tablespace, then do the stuff you need to and drop the one in the system tablespace - there is a note about it on metalink somewhere