Q: Rollback

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 Received on Wed Apr 08 1998 - 00:00:00 CDT