-
ora-1650 error
Hi all,
Oracle 8.1.7, Unix 4.3.3, SDE 8.3, IMS 4
I need to find out the user that is causing the ora-1650 error.
Any suggestions?
I am suspecting it is caused by:
In our application, when a user logs on they automatically write to a logfile (table) in the database. When they logout they remove all the entries in the table. If the user is quickly connecting/disconnecting multiple times, could that cause this error?
I don't want to just add more space to the rollback if it is a user error problem. If I can find the user, I can find out what they are doing that is suddenly causing this error.
Thx,
Kathy
-
Please disregard. I believe I found the answer. Optimal was not set and I needed to shrink the segments manually.
Thanks,