When trying to open Tools | Code Xpert it does not open and gives an object not found error in the output window, referring to the Oracle Dictionary.
Example:
Message is:
14:36:47 Oracle Dictionary: VIEW USERALPHA.XPERTV not found
Log:
v6.1.1 2009-05-06 14:36:47 Exception EOleException in module sqlnavigator.exe at 00661D95. Oracle Dictionary: VIEW USERALPHA.XPERTV not found.
The object noted in the message had been dropped from the database previously. It had at one time been added to Code Xpert and never removed from there before the object itself was dropped. Now CodeXpert won't open, so the object cannot be removed from the list through the gui.
How do you remove this object without having to recreate it, just to access Code Xpert?
Steps to reproduce:
1. SQL*Plus
SQL> create table xpert ( n number);
Table created.
SQL> create view xpertv as select n from xpert;
View created.
2. SQL Navigator
a. startup SQL Navigator
b. open CodeXpert
c. add view xpertv to the CodeXpert object list
d. close SQL Navigator
3. SQL*Plus
SQL> drop view xpertv;
View dropped.
4. SQL Navigator
a. start SQL Navigator
b. attempt to open CodeXpert. Note the exception in output and Code Xpert window does not open.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center