I have ORacle8.1.7. I createad a locally managed tablespace. I want to create a rollback segment in the same tablespace.
It is giving the following error
SQL> CREATE PUBLIC ROLLBACK SEGMENT "largerbs"
2 TABLESPACE "EPRORBS" ;
CREATE PUBLIC ROLLBACK SEGMENT "largerbs"
ERROR at line 1:
ORA-25151: Rollback Segment cannot be created in this tablespace
Any ideas Why? It's obvious I am making a mistake, but I can't figure it out.
06-26-2001, 07:38 AM
guess yous tablespace is in autoallocate extent mode, no ?
06-26-2001, 07:49 AM
I recreated the tablespace with uniform size 4m clause.
After that rollbak segment creation succedeed.
06-26-2001, 10:07 AM
you need to create one rbs in system tbs before you can successfully create any rbs in a locally managed tablespace.