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.
Information about this object is still stored in the registry and will not allow CodeXpert to open because it cannot find the object referred to.
Remove the object in question from the registry under HKEY_CURRENT_USER\Software\Quest Software\SQL Navigator 6.1.1\CodeXpert under the specific Project1 and Item###########
Example:
[HKEY_CURRENT_USER\Software\Quest Software\SQL Navigator 6.1.1\CodeXpert\Project1\Item0000000000]
"Source"="DB"
"Owner"="USERALPHA"
"Name"="XPERTV"
"Type"="VIEW"
"Connection"="USERALPHA@DBC1"
"SessionDatabase"="DBC1"
"SessionUserName"="USERALPHA"
