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

Thread: ORA-1652 and Rollback issues

  1. #1
    Join Date
    May 2000
    Location
    dallas,tx,usa
    Posts
    32

    ORA-1652 and Rollback issues

    I am getting ORA-1652 when doing a batch process. I would expect the transaction to be rolled back. This does not seem to be happening. I am using weblogic application server which on getting a sql exception will set the transaction properties on the stateless session EJB to rollback.
    The rollback feature will work fine if I get some other oracle error say a table is missing etc.
    Does anyone know of any reason why this is happening?
    thx

  2. #2
    Join Date
    May 2000
    Location
    dallas,tx,usa
    Posts
    32
    Fellow professionals pleas provide me input.
    Does Oracle auto commit the transaction if we run out of temp tablespace ?
    thx

  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    1652 error relates to extent creation failure in a tablespace.
    If the batch process did not commit prior to the failure, then the entire transaction would be rolled back. Oracle does it automatically.

    Post the complete error message.

    Did you disable autocommit feature, if you had used JAVA?

    Tamil

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    no, of course it doesnt

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