Q: Rollback
Date: 1998/04/08
Message-ID: <6gffme$hmo$1_at_news3.global-ip.net>#1/1
Hello World,
-
[Quoted]
- I used the application Oracle Database Assistant
- I set up a "TNS-name" for my db with Oracle Net8 Easy Config And did the test with system/manager [Quoted]
- I logged into to the database through/with SQL Plus8.0
- I create my tables
- I fill it with values
- I can do select, insert, delete and update
[Quoted] 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 ..."
[Quoted] 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.
[Quoted] I would like this user to have the same permissions/privilieges as [Quoted] 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
[Quoted] select, insert, delete, update and commit AND avoid the "ORA-01552: cannot
use system rollback ..."
Regards
Anders Gunnare
Received on Wed Apr 08 1998 - 00:00:00 CEST