ORA 7445 [kkobmValidInlistNode()+212] Error

Today I get the next error in a database;

 

After a little of investigation I have discoved that a new named procedure has been created. This Pl/Sql has a statement that produces the error. In mi case I hitting the Bug 8978631. It is because of using INLIST clause and conversions de b*tree indexes in bitmap. There are three solutions to solve this;

i) Patch the database (a hard work and slow)

ii) Change parameter _b_tree_bitmap_plans and set to false, at level session or database session, of course, you have permission from Oracle. (medium difficulty)

iii) Change the query, this was my solution (easy and fast)

HTH – Antonio NAVARRO

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s