System Requirements
Before installing SQL Navigator 8.0, 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. 10g Release 2 11g Release 1 and 2 12c Release 1 and 2 18c 19c 21c |
|
Citrix/Terminal Server Support |
Citrix products supported include:
For installation notes on installing SQL Navigator in a Citrix environment, refer to Getting Started | Installation. |
Supported Version Control Systems
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 | ||
|
Microsoft Team Foundation Server |
2013 |
*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. |
Supported Oracle Features
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 10g and above | |
| Object tables | YES | ||
| Queue tables + (including schedules) | NO | ||
| Index-organized tables | YES | ||
| Temporary tables | YES | ||
| External tables | YES | Oracle 10g 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 10g and above | |
| Views Hierarchies | NO | Oracle 10g and above | |
| Views with Constraints | NO | Oracle 10g and above | |
| Constraints (definition, clauses and storage) | Primary keys | YES | |
| Unique keys | YES | ||
| Foreign keys (including external FKs, views FKs) | YES | Oracle 10g 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 10g and above | |
| Descending | YES | Oracle 10g and above | |
| Reverse key | YES | ||
| Partitioned | YES | ||
| Global | YES | ||
| Local | YES | ||
| Non-prefixed | YES | ||
| Pre-fixed | YES | ||
| Function-based | YES | Oracle 10g and above | |
| Materialized views | YES | ||
| Index-Organized Materialized Views | YES | Oracle 10g and above | |
| Indexes on Materialized Views | YES | Oracle 10g and above | |
| XML, LOB, nested table, varray type columns | YES | Oracle 10g and above | |
| Materialized view Logs | NO | Oracle 10g and above | |
| Snapshot logs | NO | ||
| Record with Object ID or Sequence | NO | Oracle 10g and above | |
| Refresh groups | NO | Oracle 10g 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 10g and above | |
| TIMESTAMP WITH TIME ZONE | YES | Oracle 10g and above | |
| TIMESTAMP WITH LOCAL TIME ZONE | YES | Oracle 10g and above | |
| INTERVAL YEAR TO MONTH | YES | Oracle 10g and above | |
| INTERVAL DAY TO SECOND | YES | Oracle 10g and above | |
| Binary data types | RAW | YES | |
| LONG RAW | YES | ||
| BLOB | YES | ||
| BFILE | YES | ||
| Binary_Float | YES | Oracle 10g and above | |
| Binary_Double | YES | Oracle 10g 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 10g and above |
| XML Types | YES | Oracle 10g and above | |
| Spatial Types | NO | ||
| Media Types | NO | Oracle 10g and above | |
| Context Text Types | NO | ||
| Operators | NO | ||
| User defined | NO | Oracle 10g and above | |
| Ancillary | NO | Oracle 10g and above | |
| Triggers | Standard | YES | |
| Instead-of | YES | ||
| Database-event | YES | ||
| Nested-table view triggers | YES | Oracle 10g and above | |
| Clusters | YES | ||
| Non-hash | YES | ||
| Hash | YES | ||
| Row level dependency tracking | NO | Oracle 10g 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 10g and above | |
| Libraries | YES | ||
| Synonym | YES | ||
| Sequence | YES | ||
| Dimensions | YES | Oracle 10g and above | |
| Directories | YES | ||
| Indextypes | YES | Oracle 10g and above | |
| Jobs | YES | ||
| Outlines | NO | Oracle 10g and above | |
| Policies | NO | Oracle 10g and above | |
| Histograms | NO | ||
| Sum Deltas | NO | Oracle 10g 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 10g 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 10g and above | |
| Rulesets | NO | Oracle 10g and above | |
| External objects | NO | Oracle 10g and above | |
| Tablespaces | Standard | YES | |
| Temporary | YES | ||
| Read-only | YES | ||
| Locally managed | YES | Oracle 10g and above | |
| Transportable | YES | ||
| Undo Tablespace | NO | Oracle 10g and above | |
| Partition manipulation | YES | ||
| PL/SQL server pages | NO | Oracle 10g and above | |
| Fine grained access control | NO | ||
| Application contexts | NO | ||
| Labels (Trusted Oracle) | NO | ||
| National Language Support | NO | ||
Product Licensing
SQL Navigator is supplied with a time-limited trial key so you may test the product.
To activate a purchased commercial license
- Start SQL Navigator
- Click Tools | Product Authorization.
- Enter the Authorization key.
|
|
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.
Getting Started with SQL Navigator 8.0
Getting started with SQL Navigator 8.0
Upgrade and installation instructions
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 resources
Additional information is available from the following:
- Online product documentation: https://support.quest.com/sql-navigator-for-oracle/
- Toad World: https://forums.toadworld.com/c/sql-navigator/38
Globalization
This section contains information about installing and operating this product in non-English configurations, such as those needed by customers outside of North America. This section does not replace the materials about supported platforms and configurations found elsewhere in the product documentation.
This release supports any single-byte or multi-byte character set. It supports simultaneous operation with multilingual data. This release is targeted to support operations in the following regions: North America, Western Europe and Latin America, Central and Eastern Europe, Far-East Asia, Japan. It supports bidirectional writing (Arabic and Hebrew). The release supports Complex Script (Central Asia – India, Thailand).