<< Click to Display Table of Contents >>

Frequently Asked Questions

Top Previous Next

1.

Q:

I  upgraded KeepTool from an earlier version. It works fine when I'm connected as user SYS or SYSTEM. When I connect as another user, I get a "table or view does not exist" error.

 

A:

KeepTool is shipped with the HORA_USER  role, which grants SELECT privileges for data dictionary views. Please make sure that the HoraUser.sql script, which grants the HORA_USER role, has been executed, and the HORA_USER role has been granted to you. Please update the role after installing a new KeepTool major release.
As an alternative, you can grant the SELECT_CATALOG_ROLE that is maintained by Oracle and contains more privileges than the HORA_USER role.

2.

Q:

I have multiple ORACLE_HOMEs on my client. I can connect to the server with Oracle tools like SQL*Plus, but KeepTool cannot connect.

 

A:

Click the "Advanced .." button in the Connect dialog and make sure an Oracle Home is found.
For 32-Bit KeepTool a 32-Bit Oracle client is needed. For 64-Bit KeepTool a 64-Bit Oracle client is needed.

3.

Q:

How can I change the date format in KeepTool displays? I assume that KeepTool does not use client settings from Oracle.

 

A:

To display the date and time, KeepTool uses the regional settings from Windows. You must change the date format in the Windows control panel.

4.

Q:

What is the difference between table relations and object dependencies?

 

A:

Table Relations shows referential integrity constraints defined by foreign keys. Dependencies between objects (of different types) show which objects become invalid after they have been changed.

5.

Q:

PL/SQL Debugger "hangs" as soon as I try to start executing my calling block. What can be done?

 

A:

Sometimes problems occur within the Oracle-supplied DBMS_DEBUG package. Often, running the pbload.sql script in your $ORACLE_HOME\RDBMS\Admin folder will clear these up.

6.

Q:

Why do certain non-ASCII characters appear as question marks when I connect using a direct TCP/IP connection, but appear correctly when using the Oracle client?

 

A:

When using the Oracle client to connect to the database, KeepTool issues certain ALTER SESSION commands to set the NLS environment, based on the contents of HKLM/Software/Oracle. If you connect via direct TCP/IP, this registry key is not referenced, since it may not exist. You can specify your own startup script in the connect dialog to initialize your NLS environment.

7.

Q:

Where does Hora store recent connections and other settings?

 

A:

Recent connections and editor settings are stored in XML and Text files below %APPDATA%\KeepTool14\Projects\.

Other information is saved in the registry below HKCU\Software\KeepTool\14.