-
creating table give ora-01552....so try to create public rollback also hit ora-1552..
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.
-
create another rollback segment.
The man called Zorro
-
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
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
|