Re: Q: Rollback

Anders Gunnare wrote:  

<snip>

> 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

Hi Anders

1. Create 1 or more additional rollback segment for public use (create public...), so that anyone can access it. The number depends on the design of your DB. In general, avoid to use the system rollback segment.
2. Check that your rollback segments will be online after restart of the database (entry in the init<ORACLE_SID>.ora file, ROLLBACK_SEGMENTS=(name of the rollback segments)

This should help
eugen Received on Thu Apr 09 1998 - 00:00:00 CDT