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

Thread: Hung Update statement

  1. #1
    Join Date
    Dec 1999
    Posts
    217

    Hung Update statement

    I have an update statement (UPDATE TABX SET START_EXTRACT = 'C') running on the database via a script. This script basically extracts data from the user schema, writes it to a file on the UNIX server and then goes in the database and sets a flag off. Apparently, I see the connection has been made to the database and I do see the session as 'Active' but the update statement is not executed.
    What do I do to see why the update statement is not being committed?

    Yopur input is highly appreciated..

    Thanks,
    Chintz

  2. #2
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    Are using commit? After how many rows?

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

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