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