Re: Q: Rollback

Anders Gunnare wrote:
>
> Hello World,
>
> 1) I used the application Oracle Database Assistant
> 2) I set up a "TNS-name" for my db with Oracle Net8 Easy Config
> And did the test with system/manager
> 3) I logged into to the database through/with SQL Plus8.0
> 4) I create my tables
> 5) I fill it with values
> 6) I can do select, insert, delete and update
>
> So far so good...
>
> Bu now I restart the machine.
> And I logged into to the database through/with SQL Plus8.0
> and tries to do an insert or delete.
>
> But now I get the error "ORA-01552: cannot use system rollback ..."
>
> At this point I would like to do the following:
> 1) Create a new user/passwd with access to my db and which can do
> select, insert, delete, update and commit.
>
> I would like this user to have the same permissions/privilieges as
> scott/tiger to orcl.
>
> So my question to you is:
> How do I Create a new user/passwd with access to my db and which can do
> select, insert, delete, update and commit AND avoid the "ORA-01552: cannot
> use system rollback ..."
>
> Regards
> Anders Gunnare

I once had the same trouble and I resolved it by creating a new and bigger system rollback segment. In general I've had more trouble with rollback segments than with anything else.

-- 
Femi Aderounmu
New Jersey
--