Oracle 8

[budding]

Hi there,
To create a new user, I first created a tablespace and then assigned this user to that newly created tablespace. In the new user's schema, I could create a table but when I tried to insert data into the table, I got an error stating:
"Cannot use system rollback segment for non system tablespace".

Why is this??? I then created an user without assigning to any tablespace(that is to the default tablespace "system&quot, it works fine..Could anyone please explain me this.

As a new entry into the admin side, the response to this would be appreciated.

Ta..

kk

 

[karluk]

I sounds as if you are trying to configure a new database. One of the necessary tasks is to create a tablespace just for rollback segments and then (of course) to create rollbacks segments in it. That will allow your new user to allocate rollback segments without using the system rollback segment.

If you have already done this, the odds are that your new rollback segments are not online. You can force them online at instance startup with a parameter in your initialization file. I don't have a reference handy, but I think the syntax is

ROLLBACK_SEGMENTS = (list of rollback segs, separated by commas)