Table 5: Known Issues
| Feature | Known Issue | Issue ID |
|---|---|---|
| F1 Help |
Pre-open F1 help is unresponsive when there is a modal dialog opened in SQL Navigator. Workaround: Close the modal dialog and then switch to the help window |
SQLNAV-260 |
| Export Data |
Export Data containing special characters from data grid to xlsx format may corrupt the Excel file. This usually happens when binary content is exported from a BLOB field. Workaround: Exclude the rows or columns which contain binary data or special characters when using the Export Data dialog |
SQLNAV-1609 |
| Stored procedure | Error message received while executing a stored procedure when the table is not present in the database, is not clear. | SQLNAV-2421 |
| License | When a user attempts to activate the 'Developer Edition' license, SQL Navigator displays incorrect licensed version information in the 'About SQL Navigator' window. | SQLNAV-2438 |
| SQL Navigator | SQL Navigator displays incorrect license information on the "About SQL Navigator" window when a user tries activating the "Developer Edition" license. | SQLNAV-2438 |
| Case statement | The Output window on the Profile Code page displays an incorrect count under the Code Statistics Summary section. | SQLNAV-2442 |
| Source preview | SQL Navigator is not displaying source code previews for any object in the Source Preview window. | SQLNAV-2444 |
| Explain Plan | The Explain Plan is not displaying the required parameters when opened using the Explain Plan icon in the icon tray. | SQLNAV-2447 |
| Installation | The Result section on the 'SQL Navigator Server Side Installation' window is not displaying the status of the server-side installation when the installation fails. | SQLNAV-2449 |
| Oracle 26ai | SQL Navigator for Oracle 26 AI currently does not support the XML, JSON, BOOLEAN, and VECTOR data types. | SQLNAV-2497 |
| Constraints | SQL Navigator may display an error when users attempt to modify constraints. This issue has been observed on Oracle 23ai and 19c databases. | SQLNAV-2512 |
| Session Browser | SQL Navigator displays the List index out of bounds error when users open the Session Browser with multiple active sessions. | SQLNAV-2517 |
| Code Assist | Code Assist (IntelliSense) does not support Common Table Expressions (CTEs) or IF/ELSE blocks and displays an exception when these constructs are used. | SQLNAV-2518 |
Table 6: Third Party Known Issues
| Feature | Known Issue | Issue ID |
|---|---|---|
| Oracle | When users connect to the Oracle 19c database for the first time after upgrading from an Oracle 12c database, SQL Navigator displays an error. This issue is particularly observed with tables containing XMLTYPE columns. | N/A |
| E-Control (Editor component) | Odd word-wrapping behavior in some languages. Word wrapping may appear between symbols, with no space required to wrap, and some characters cannot be word-wrapped at all (for example, multi-byte characters in ANSI text). | N/A |
| ODAC | ODAC does not support Unicode in XMLTYPE (editing of XMLTYPE data is not supported). Querying of XMLTYPE with binary storage will lead to an error. |
Before installing SQL Navigator 8.1, ensure that your system meets the following minimum hardware and software requirements.
|
Memory |
1 GB RAM required for 32-bit 2 GB RAM required for 64-bit The memory required may vary based on the following:
|
|
Hard Disk Space |
120 MB required for 32-bit 150 MB required for 64-bit More disk space is required for SQL Navigator Xpert, less for SQL Navigator Standard and SQL Navigator Professional. |
|
Operating System |
|
|
Oracle Client |
You must use the 32-bit version of SQL Navigator with the 32-bit Oracle client, and the 64-bit version of SQL Navigator with the 64-bit Oracle client. |
|
Oracle Server |
The following Oracle database servers are supported.
|
|
Citrix/Terminal Server Support |
Citrix products supported include:
For installation notes on installing SQL Navigator in a Citrix environment, refer to Getting Started | Installation. |
You can use a version control system (VCS) in conjunction with Team Coding to control files and database objects. SQL Navigator provides direct support to specific third-party version control systems and it also provides SCC support to connect to additional version control systems. You must have Team Coding installed to work with a VCS through SQL Navigator.
|
|
Important: Quest Software is unable to provide support for source control issues caused by the version control system, including the version control system's support for the Microsoft SCC API. If you have problems connecting to SQL Navigator through SCC, contact the version control system's support. |
Direct Supported
| Version Control System | Version | ||
|---|---|---|---|
| Concurrent Versions System (CVS)* |
CVS 1.11.9 and later CVSNT 2.08 and later | ||
|
Git * |
A git client for Windows must be installed. | ||
|
IBM Rational ClearCase * |
Version 7.1 for Windows. ClearTool command line is required.
| ||
|
Perforce * |
2010.2 (command-line client)
| ||
|
Serena PVCS * |
5.2 and later
Serena PVCS Version Manager:
| ||
|
Apache Subversion (SVN)* |
1.7 and later | ||
| Azure DevOps Support |
Azure DevOps Services (TFVC) Azure DevOps Server 2019, 2020 and 2022 |
*These version control systems connect using a command-line client.
SCC Support
In addition to providing direct support to the version control systems, SQL Navigator supports additional version control systems through the Microsoft SCC API. You should be able to connect to any version control system that uses SCC.
To connect to a version control system using SCC, you must install the system's SCC-compliant client. See the system's documentation for instructions on how to install their SCC client.
|
|
Note: It is strongly recommended you use the native APIs for PVCS when using Team Coding (instead of the SCC integration). Most version control systems that integrate with SQL Navigator through the SCC API ignore the "Force revision" flag and the "Create a new revision for existing objects" option when exporting. |
SQL Navigator supports the following Oracle features.
A support of YES indicates the feature is supported fully or partially.
| Oracle feature | Support | ||
|---|---|---|---|
| Tables | Standard relational tables | YES | |
| Partitioned (range, hash and composite) Tables | YES | ||
| Partitioned (list) Tables | YES | Oracle 12c and above | |
| Object tables | YES | ||
| Queue tables + (including schedules) | NO | ||
| Index-organized tables | YES | ||
| Temporary tables | YES | ||
| External tables | YES | Oracle 12c and above | |
| Views | Standard views | YES | |
| Inline views | YES | ||
| Object views | YES | ||
| Join views (including updateable) | YES | ||
| Check option on views | YES | ||
| Read only option on views | YES | ||
| Polymorphic Views | NO | Oracle 12c and above | |
| Views Hierarchies | NO | Oracle 12c and above | |
| Views with Constraints | NO | Oracle 12c and above | |
| Constraints (definition, clauses and storage) | Primary keys | YES | |
| Unique keys | YES | ||
| Foreign keys (including external FKs, views FKs) | YES | Oracle 12c and above for views FKs | |
| Procedures | YES | ||
| Java/C Methods Calls | YES | ||
| Invokers Right | YES | ||
| Functions | YES | ||
| Java/C Methods Calls | YES | ||
| Invokers Right | YES | ||
| Packages | YES | ||
| Header | YES | ||
| Body | YES | ||
| Invokers Right | YES | ||
| Indexes | Standard | YES | |
| Bitmap | YES | ||
| Bitmap Join Index | NO | Oracle 12c and above | |
| Descending | YES | Oracle 12c and above | |
| Reverse key | YES | ||
| Partitioned | YES | ||
| Global | YES | ||
| Local | YES | ||
| Non-prefixed | YES | ||
| Pre-fixed | YES | ||
| Function-based | YES | Oracle 12c and above | |
| Materialized views | YES | ||
| Index-Organized Materialized Views | YES | Oracle 12c and above | |
| Indexes on Materialized Views | YES | Oracle 12c and above | |
| XML, LOB, nested table, varray type columns | YES | Oracle 12c and above | |
| Materialized view Logs | NO | Oracle 12c and above | |
| Snapshot logs | NO | ||
| Record with Object ID or Sequence | NO | Oracle 12c and above | |
| Refresh groups | NO | Oracle 12c and above | |
| Datatypes | Built-in Datatypes | YES | |
| Character | YES | ||
| CHAR | YES | ||
| NCHAR | YES | ||
| VARCHAR2 | YES | ||
| NVARCHAR2 | YES | ||
| LONG | YES | ||
| CLOB | YES | ||
| NCLOB | YES | ||
| Number | YES | ||
| Date types | DATE | YES | |
| TIMESTAMP | YES | Oracle 12c and above | |
| TIMESTAMP WITH TIME ZONE | YES | Oracle 12c and above | |
| TIMESTAMP WITH LOCAL TIME ZONE | YES | Oracle 12c and above | |
| INTERVAL YEAR TO MONTH | YES | Oracle 12c and above | |
| INTERVAL DAY TO SECOND | YES | Oracle 12c and above | |
| Binary data types | RAW | YES | |
| LONG RAW | YES | ||
| BLOB | YES | ||
| BFILE | YES | ||
| Binary_Float | YES | Oracle 12c and above | |
| Binary_Double | YES | Oracle 12c and above | |
| Ids | ROWID | YES | |
| UROWID | YES | ||
| ANSI DB2, SQL/DS datatypes | YES | ||
| User defined data types | Collection Types | YES | |
| Object Types | YES | ||
| Oracle Supplied types | "Any" Types | NO | Oracle 12c and above |
| XML Types | YES | Oracle 12c and above | |
| Spatial Types | NO | ||
| Media Types | NO | Oracle 12c and above | |
| Context Text Types | NO | ||
| Operators | NO | ||
| User defined | NO | Oracle 12c and above | |
| Ancillary | NO | Oracle 12c and above | |
| Triggers | Standard | YES | |
| Instead-of | YES | ||
| Database-event | YES | ||
| Nested-table view triggers | YES | Oracle 12c and above | |
| Clusters | YES | ||
| Non-hash | YES | ||
| Hash | YES | ||
| Row level dependency tracking | NO | Oracle 12c and above | |
| Collections | YES | ||
| Nested tables | YES | ||
| VARRAYs | YES | ||
| Java support | JDBC code | NO | |
| SQLJ code | NO | ||
| JAVA SOURCE | YES | ||
| JAVA CLASS | YES | ||
| JAVA RESOURCE | YES | ||
| Database links | YES | ||
| PFILE, SPFILE | NO | Oracle 12c and above | |
| Libraries | YES | ||
| Synonym | YES | ||
| Sequence | YES | ||
| Dimensions | YES | Oracle 12c and above | |
| Directories | YES | ||
| Indextypes | YES | Oracle 12c and above | |
| Jobs | YES | ||
| Outlines | NO | Oracle 12c and above | |
| Policies | NO | Oracle 12c and above | |
| Histograms | NO | ||
| Sum Deltas | NO | Oracle 12c and above | |
| Object support | Types | YES | |
| Attributes | YES | ||
| Methods | YES | ||
| REF support (columns and attributes) | YES | ||
| Inheritance | NO | ||
| Substitutability | NO | ||
| Polymorphism | NO | ||
| User defined statistics | NO | Oracle 12c and above | |
| Context Namespaces | NO | ||
| Audit options | NO | ||
| Profiles | YES | ||
| Roles | YES | ||
| Privileges | YES | ||
| Resources | Resource plans | NO | |
| Consumer groups | NO | ||
| Plan Directives | NO | ||
| Allocation method | NO | ||
| Alter Resource Cost dynamically | NO | Oracle 12c and above | |
| Rulesets | NO | Oracle 12c and above | |
| External objects | NO | Oracle 12c and above | |
| Tablespaces | Standard | YES | |
| Temporary | YES | ||
| Read-only | YES | ||
| Locally managed | YES | Oracle 12c and above | |
| Transportable | YES | ||
| Undo Tablespace | NO | Oracle 12c and above | |
| Partition manipulation | YES | ||
| PL/SQL server pages | NO | Oracle 12c and above | |
| Fine grained access control | NO | ||
| Application contexts | NO | ||
| Labels (Trusted Oracle) | NO | ||
| National Language Support | NO | ||
SQL Navigator is supplied with a time-limited trial key so you may test the product.
To activate a purchased commercial license
|
|
Note: The Windows user that licenses SQL Navigator requires certain write-access privileges and therefore must be a member of either the Administrators group within Windows, or have equivalent privileges. |
SQL Navigator suite includes the following products:
SQL Navigator
SQL Optimizer for Oracle
Code Tester for Oracle
Benchmark Factory*
*The Benchmark Factory product requires a separate license key for activation.
Refer to the Installation Notes for installation instructions.
Upgrades for SQL Navigator install side-by-side with previous versions. You can run the new and previous versions concurrently. The first time you run the new version of SQL Navigator, you can import settings files from the previous versions via Tools | Profile Manager.
Additional information is available from the following:
