Main Menu Keyboard Shortcuts
Navigation > Main Menu Keyboard Shortcuts
Generally available keyboard shortcuts are: Close Current Window = CTRL+F4 | Refresh = F5.
Customize The Screen Layout
Navigation > Customize The Screen Layout
Float / Dock
You can save multiple screen layouts of floating / docked items as per the View Menu | Screen Layout.
|
|
TIP: While moving a dockable item you can prevent it from docking by holding down the CTRL key. |
|
Main Menu Bar |
The main menu bar can be floating or docked. |
|
Dockable Windows |
The following windows are dockable. They can be docked to any side of the SQL Navigator application window or any other dockable window. You can dock several windows to the same site.
Dockable windows open in the same state (floating or docked) and in the same screen position or at the same site as when they were last closed. Dockable windows retain size and position between sessions.
The size and location of dockable windows are remembered in screen layouts as per View Menu | Screen Layout.
|
|
Note:
- The size and location of the Output Window is remembered only when docked.
- When the Output Window is docked, the Output Window remains visible ("on top") when other windows are opened. When the Output Window is not docked it can be hidden behind the current window.
| |
|
Toolbars available in the Main Window |
The toolbars can be docked to any side of the SQL Navigator application window or can float on top of the current window. |
|
Task Bar |
The task bar can be docked to any side of the SQL Navigator application window or can float |
Toolbars in the Main Window
| Show/Hide Buttons |
-
If the toolbar is docked, click the down arrow to the far right of the toolbar.
If the toolbar is floating, click the down arrow on the title bar.
- Click Add or Remove Buttons.
- Select the buttons to show.
|
|
Add/Remove Toolbars.
Reorder Items.
Add items from a master list. |
-
If the toolbar is docked, click the down arrow to the far right of the toolbar.
If the toolbar is floating, click the down arrow on the title bar.
- Click Add or Remove Buttons | Customize.
|
|
TIP: While the Customize dialog is open, move the mouse pointer over a toolbar button and right click. Choose an option from the shortcut menu. Reset the toolbar, delete or rename the button, change its appearance or add a separator. | |
| Reset the Toolbar to Default. |
-
If the toolbar is docked, click the down arrow to the far right of the toolbar.
If the toolbar is floating, click the down arrow on the title bar.
- Click Add or Remove Buttons | Reset Toolbar.
|
Main Menu Bar
| Customizable Menu Items |
While the menu is docked, click the down arrow in the far right corner. If the menu is floating, click the down arrow on the title bar. |
Oracle Logon
Oracle Logon Dialog
Oracle Logon > Oracle Logon Dialog
Manage your database connections, including to create a database connection.
Oracle Client Settings
| Oracle Home/Client |
Select from the list of available Oracle Home names. |
| TNSNAMES/LDAP/SQLNET Configuration File Path |
The location of your Oracle configuration files. |
| Names.Directory_Path |
As specified in your sqlnet.ora file. |
Connection Parameters
Fill in the fields for one of the TNS, Direct or LDAP tabs.
TNS
| Database |
Select from the list of database connections in the TNSNAMES.ora file. |
Direct
DIRECT is used for Direct Connection.
| Host |
Enter the name or IP address of the machine which hosts the Oracle server. |
| Port |
Enter the port number for the Oracle server. |
| Service Name |
Enter the service name of the Oracle server. |
| SID |
Enter the Oracle System Identifier (SID) of the Oracle server. Use this option when connecting to an instance running a version earlier than Oracle 8.1. |
LDAP
Select from the databases on the LDAP server.
Username / Password
|
Username |
Your Oracle username to the database.
When Save Password is selected the username field automatically recalls username/password combinations based on the first letter(s) entered into the field. |
|
Password |
Your Oracle password to the database/username combination. |
|
Save password |
Select to save the password for this database/username combination.
|
|
Note:
- Your password is saved in encrypted format.
- Ensure you have safeguards in place to prevent other users from physical access to your computer (for example, automatic keyboard locking).
- If you have saved a password then deselect Save Password to delete it.
| |
|
TNSNames Editor |
Add a new service and configure the TNSNames.ora file: Oracle TNS Configuration. |
|
|
TIP: To change the logon password for the active connection: Close this dialog. Select Session | Change Password to open Change Logon Password. |
Options
|
Bytes per Character |
Allow the system to automatically detect the number of bytes per character for the connection or select from the list of available numbers.
The default preference is set in View | Preferences | General | Session. If you receive ORA-01026 errors (or similar) when working with the database, we recommend setting this preference to the minimum possible value (2, 3 or 4) that eliminates the errors. |
|
Connect As |
Select the type of system privileges you want to use for this connection—Normal, SYSDBA, or SYSOPER.
Your Username must first be granted these privileges. For information about system privileges, see the Oracle Database Administrator’s guide. |
|
Enable using DBA views |
| Selected |
Use DBA views to query the Oracle Data Dictionary. |
| Not Selected |
Use ALL views to query the Oracle Data Dictionary. |
For more information, see DBA Dictionary Views.
Your Username must first be granted appropriate Oracle privileges. |
|
Enable Trace |
When selected, SQL Navigator generates a log file of database operations and results. Quest Support may request you enable trace for troubleshooting purposes.
Enabling Trace slows down your access to the database. |
|
Category |
Optionally, assign to the connection a category color. For more information, see Connection Category Color. |
