ora-1650 error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ora-1650 error

  1. #1
    Join Date
    Nov 2000
    Posts
    172

    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

  2. #2
    Join Date
    Nov 2000
    Posts
    172
    Please disregard. I believe I found the answer. Optimal was not set and I needed to shrink the segments manually.

    Thanks,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width