Oracle Scratchpad

December 15, 2006

ORA-01722: upgrade error

Filed under: CBO, Hints, Troubleshooting — Jonathan Lewis @ 10:33 pm UTC Dec 15,2006

I received an email recently from someone who had just upgraded the Oracle 11i Business Suite (11.5.9) from 9.2.0.6 to 10.2.0.2.  After the upgrade, the following SQL statement (shown here with its original format – not according to my standards) started failing with Oracle error: ORA-01722: invalid number.
(more…)

Index Operations

Filed under: Execution plans, Indexing, Tuning — Jonathan Lewis @ 9:17 pm UTC Dec 15,2006

Just a little note on two index operations that you might see in an execution plan that are worth highlighting because it’s so easy to miss just one critical word in the name of the operation.
(more…)

Blog at WordPress.com.