SQL Navigator for Oracle - Knowledge Base

Filter Your Results
Search All Products

Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
Featured Content
What's new in SQL Navigator 7.4?
How to find the license number
Contact Us
Technical Support
View All

Search Knowledge Base by keyword

(Choose different product)



Sort By Last Updated
Displaying 1-25 of 1058
Tnsnames entries in the connection list are missing .WORLD extension (256042)

In v7.4 there is an issue where the .WORLD domain on the tnsnames.ora entry is missing in the SQL Navigator connection screen, and has to be entered manually to connect. Then once a connection is established, the .WORLD ...

Product(s): SQL Navigator for Oracle
Last Updated On: 5/22/2018
(0 Ratings) 10 views
Trigger code missing BEFORE/AFTER keywords when Generate DDL script is pressed (255515)

There is an issue when viewing the Generate DDL script with triggers on editioning views. The problem is that there is no BEFORE/AFTER keyword in generated DDL. WORKAROUND. Look for the trigger with "Find Objects" option. ...

Product(s): SQL Navigator for Oracle
Last Updated On: 5/14/2018
(0 Ratings) 12 views
Toad installation error: The installer was not able to complete successfully. (189788)

Unable to install product suite. When trying to install Toad, getting the error below. The issue happens on the .EXE file, but can also happen on the .MSI file. ERROR: "The installer was not able to complete successfully. RegisterComplete returned error code [0x80070005]. ...

Product(s): Toad for SAP Solutions, Toad Data Point, Toad for DB2, Toad for SQL...
Last Updated On: 5/7/2018
(1 Ratings) 12696 views
Can't login to Toad. What is the Toad password? Where do I get my login credentials? What is my user name and password? (80949)

Cannot or unable to login. What is the Toad password? Where do I get my login credentials? What is my username and password? The account is locked so it needs to be unlocked and the password reset. There is a prompt ...

Product(s): Toad Edge, Toad for SAP Solutions, Toad Data Point, Toad Data Modeler...
Last Updated On: 5/4/2018
(2 Ratings) 15493 views
"DBA-Audit" record created with the error "ORA-01403" (254977)

There are no error messages in SQL Navigator, it runs just fine, but it is creating a "ORA-01403" record in the "DBA-Audit" Table when connecting to a 12c release 2 Server: ====. BEGIN. SELECT ...

Product(s): SQL Navigator for Oracle
Last Updated On: 5/2/2018
(0 Ratings) 12 views
Unable to create a backup using SQL Navigator Profile Manager 7.4 (254974)

Cannot take backup using SQL Navigator Profile Manager 7.4. It only creates 1KB files, regardless of how big the profile should be. NOTE: SQL Navigator Profile Manager 7.1 works fine in the same PC. WORKAROUND: none. STATUS: ...

Product(s): SQL Navigator for Oracle
Last Updated On: 5/2/2018
(0 Ratings) 8 views
A check-out operation is automatically made even it is not desired (248695)

A check-out operation is automatically made even it is not desired. When a module is opened in Team Coding and the VSS version differs from the database version, a prompt displays with the option to choose to see the database or VSS version. ...

Product(s): SQL Navigator for Oracle
Last Updated On: 4/20/2018
(0 Ratings) 5 views
Changes in the v7.4 Formatter breaks the history for code in version management systems (249774)

In v7.4, code is formatted differently by default, compared to that of v7.3. This becomes an issue because it breaks the history in version management systems. WORKAROUND: Currently the only workaround is to use v7.4 to format all source again. ...

Product(s): SQL Navigator for Oracle
Last Updated On: 3/20/2018
(0 Ratings) 6 views
Would it be possible to have a trial installer that does not need access to internet during the installation? (239039)

Assistance with installation of trial without internet access Contact Support and ask for the msi trial installer for SQL Navigator for Oracle.

Product(s): SQL Navigator for Oracle
Last Updated On: 3/19/2018
(0 Ratings) 7 views
How to create the Support Bundle file in Toad (229559)

How to create the Support Bundle file in Toad In Toad for Oracle: Support Bundle: Can be found in Toad menu| Help | Support bundle >> Then click on the Support Bundle Tab and save this text file file in the Desktop. In Toad Data Point: ...

Product(s): Toad Data Point, Toad for Oracle, SQL Navigator for Oracle
Last Updated On: 3/19/2018
(0 Ratings) 1290 views
The 'Nav_CFU.ini' file grows to a very large size when choosing 'Check for Updates' option (248434)

When you choose the Help | Check For Updates option in SQL Navigator, if you monitor the \AppData\Roaming\Quest Software\SQL Navigator 7.4.0\CFU\Nav_CFU.ini file, it grows to a very large size, very quickly - and SQL Navigator seems to hang at the same time. ...

Product(s): SQL Navigator for Oracle
Last Updated On: 3/14/2018
(0 Ratings) 3 views
Get "Error 1325. 'Favorites' is not a valid short file name" during install (145398)

When installing the SQL Navigator executable, getting a 1603 error. Looking in the "C:\ProgramData\Quest Software\Quest Installer\Logs\ sqlnav_7.1.0.3676_32bit.msi.log" file, the true error is found: Error 1325. 'Favorites' is not a valid short file name. CAUSE 1: ...

Product(s): SQL Navigator for Oracle
Last Updated On: 2/27/2018
(1 Ratings) 8238 views
Access Violation when trying to read XMLTYPE column. (242315)

Tables with XMLTYPE columns returns an error message similar to this when SQL Navigator tries to read from them: "[1]:(Error): Access violation at address 000007FED4C71C7A in module 'OraOCIEI12.dll'. Read of address 0000000000000010". WORKAROUND: NONE. ...

Product(s): SQL Navigator for Oracle
Last Updated On: 2/23/2018
(0 Ratings)
Who to contact to renew Support Maintenance Contract? (58244)

Who to contact to renew a Support Maintenance Contract? To renew your support maintenance contract, please contact the Customer Support Renewals department. One can Renew Support maintenance contract here.

Product(s): Code Tester for Oracle, Toad Data Point, Toad for DB2, Toad for SQL...
Last Updated On: 2/8/2018
(0 Ratings) 6214 views
SQL Navigator asks to enter the license key every time a user logs onto Terminal Server (240236)

If SQL Navigator is installed in a terminal server environment, where the user profiles are removed when the user logs off, SQL Navigator prompts for a license key, every time the user logs back onto the Terminal Server and opens SQL Navigator. ...

Product(s): SQL Navigator for Oracle
Last Updated On: 2/7/2018
(0 Ratings) 1 views
Sometimes a module is set to read only even if it is checked out (239874)

In TeamCoding, a module is set to read only even if it is checked out. This is a sporadic issue. The cause of this issue is unknown. WORKAROUND Close the Edit window and open it again in order to be able to type.

Product(s): SQL Navigator for Oracle
Last Updated On: 2/6/2018
(0 Ratings) 1 views
"Check for Updates" returns incorrect information (239044)

When clicking on Help | Check for Updates, SQL Navigator provides an incorrect update version (7.0.1) instead of the latest version available. The download link button also points to an incorrect download page. Older versions ...

Product(s): SQL Navigator for Oracle
Last Updated On: 1/30/2018
(0 Ratings) 4 views
Error in tool View difference when open big package or comparing schemas (212344)

SQL Navigator crashes when running "view difference" with play button (reload and re-compare) for long packages or DB schemas with the “Line out of bounds” error. WORKAROUND. Confirm the error "Line out of bounds" several times. ...

Product(s): SQL Navigator for Oracle
Last Updated On: 1/15/2018
(0 Ratings) 1102 views
When checking-out and checking-in a package, both spec and body are selected by Toad (237034)

In Team Coding when checking-out a package, there are check boxes to individually select the spec and body of the package. When only checking-in the body, Toad also tries to check-in the spec and sends a message to inform that the module was not checked out. ...

Product(s): SQL Navigator for Oracle
Last Updated On: 1/8/2018
(0 Ratings) 2 views
Where can tutorials be found for SQL Tuning? (19603)

Where can tutorials be found for SQL Tuning? How can queries be optimized in Toad ? There are new improvements regarding SQL Tuning in Toad for Oracle. The best option is taking the training course for Toad for Oracle - Performance- Management. ...

Product(s): QCO SQL Tuning, Toad Xpert Tuning, SQLNav Xpert Tuning, Toad for Oracle...
Last Updated On: 12/22/2017
(0 Ratings) 6811 views
Installation, Unable to install product, "HTTPs Error: This package download process are interrupted, error code [0x80072EFE] or [0x80072EFF] or [0x80070642] or [0x80070EFD] (229235)

Unable to install product suite. When trying to perform the installation via Bundle installer, getting the Https error. The issue happens on the web installer then your internet connection is unreachable. ERROR: "HTTPs Error: This package download processes are interrupted. ...

Product(s): Toad for SAP Solutions, Toad Data Point, Toad for DB2, Toad for SQL...
Last Updated On: 12/7/2017
(0 Ratings) 3009 views
SQL Optimizer does not recognize the SQL Navigator Development Suite license key (234865)

SQL Navigator is installed on a machine and has a Development Suite license key entered in it. On the same machine is SQL Optimizer for Oracle. The Development Suite key should give access to SQL Optimizer, but SQL Optimizer is not recognizing the license key. ...

Product(s): SQL Optimizer for Oracle, SQL Navigator for Oracle
Last Updated On: 11/28/2017
(0 Ratings) 616 views
'ORA-28009: connection as SYS should be as SYSDBA or SYSOPER' when reconnecting a SYSDBA session (234478)

In v7.4, When you connect as the SYS user (as SYSDBA) and then go to Session | Reconnect, SQL Navigator doesn't reconnect, with the error: 'Error occurred: [28009] (ORA-28009: connection as SYS should be as SYSDBA or SYSOPER)' This only happens for the SYS user ...

Product(s): SQL Navigator for Oracle
Last Updated On: 11/13/2017
(0 Ratings) 34 views
The auto-complete functionality doesn't work properly when referencing a wrapped package spec in the Editor (234480)

In v7.4, the auto-complete functionality doesn't work properly when referencing a wrapped package spec in the Editor. After typing the '.' the auto-complete box pops up for a brief second and disappears. In v6.x, it works fine on the same wrapped package spec. ...

Product(s): SQL Navigator for Oracle
Last Updated On: 11/13/2017
(0 Ratings) 40 views
Prompt for check in all on exit setting does not work (234341)

Under Team coding options, setting "Prompt for check-in all on exit" does not work. When this option is selected, SQL Navigator does not prompt anything when closing it, even though there are objects checked out. This happens ...

Product(s): SQL Navigator for Oracle
Last Updated On: 11/7/2017
(0 Ratings) 39 views