-
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
-
Fellow professionals pleas provide me input.
Does Oracle auto commit the transaction if we run out of temp tablespace ?
thx
-
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
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|