From: Eugen Nyffeler <eugen.nyffeler@ubs.com>
Subject: Re: Q: Rollback
Date: 1998/04/09
Message-ID: <352C8AF9.57D892EB@ubs.com>#1/1
Content-Transfer-Encoding: 7bit
References: <6gffme$hmo$1@news3.global-ip.net>
Content-Type: text/plain; charset=us-ascii
Organization: Union Bank of Switzerland 
Mime-Version: 1.0
Reply-To: eugen.nyffeler@ubs.com
Newsgroups: cern.oracle,cern.oracle.cde,comp.databases.oracle.marketplace,comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools,fido7.rdbms.oracle,hannover.uni.comp.oracle



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