Error ORA-14450: attempt to access a transactional temp table already in use

Posted on 2009-04-30
Last Modified: 2013-12-10
I get the following error code in the application log

ORA-14450: attempt to access a transactional temp table already in use

this application runs on Weblogic App servers in a cluster of 6 maanged servers on 6 physical servers, but this error is seen just on the two managed server app logs
Question by:cha513
    1 Comment
    LVL 10

    Accepted Solution

    Well, looks like this is a classic ORACLE error and the fix is to reconnect the oracle connection.

    Do you have physical reconnect timeout in your JDBC/Datastore. There has to be an option wherein the connection would automatically close physically and a new connection would be restored in the JDBC pool. May be you can explore that option and set it to a lower value to check if this error is happening still (lowering the value means, the connection would be closed refreshed physically soon)



    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    -Xmx and -Xms are the two JVM options often used to tune JVM heap size.   Here are some common mistakes made when using them:   Assume BigApp is a java class file for the below examples. 1.         Missing m, M, g or G at the end …
    This article is about some of the basic and important steps to be used to improve the performance in web-sphere commerce application development. 1) Always leverage the Dyna-caching facility provided by the product 2) Remove the unwanted code …
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now