Failed to rebuild node contents: OALL8 is in an inconsistent state error

Posted on 2006-04-16
Last Modified: 2012-06-27
Hi Experts,

I have connected oracle DB via aqua data studio and I have this error("Failed to rebuild node contents: OALL8 is in an inconsistent state") when I click tables/views folder from aqua data studio explorer and I can't even excute query in query analyzer. I might have made my oracle schema inconsistent. While I was testing my program, I had this "maximum open cursors exceeded" error a few times and I am wondering if this error has anything to do this problem that I am having.

I apprecicate any input.
Question by:dkim18
    1 Comment
    LVL 19

    Accepted Solution

    aqua data studio, if I am right, is using JDBC to connect to oracle database.

    if this is the case, the problem has nothing to do with "maximum open cursors" (this is casued usually by your client software or apps)


    This is known to occur under when you are using too big an array size. How big your array can be depends on the length of each record and the Driver/Database combination. If you exceed the maximum size you will get the "OALL8" SQLException and your connection object may become unusable.

    This message is also created if you are using the following:
    9.0.1 Database
    10.1.0 JDBC Driver
    Generated Code that passes in an ARRAY or VARRAY of VARCHAR2 as a Parameter

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
    Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
    Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
    This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

    734 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

    20 Experts available now in Live!

    Get 1:1 Help Now