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:

  • Applications that are running on your system
  • Size and complexity of the database
  • Amount of database activity
  • Number of concurrent users accessing the database

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

  • Windows 8.1

  • Windows 10

  • Windows 11

  • Windows Server 2012 R2

  • Windows Server 2016

  • Windows Server 2019

  • Windows Server 2022

Oracle Client

  • Oracle Client or Instant Client 10.2.0.5

  • Oracle Client or Instant Client 11.2.0.1/11.2.0.3

  • Oracle Client or Instant Client 12c Release 1 and 2

  • Oracle Client or Instant Client 18c

  • Oracle Client or Instant Client 19c

  • Oracle Client or Instant Client 21c

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:

  • Platform Level - MetaFrame XPa 1.0 Server for Windows
  • Feature Release - MetaFrame XP 1.0, Feature Release 1,2 and 3.

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.

Note: You must set up a working client view, mapped to the Project VOB on the client computer, before using it in SQL Navigator.

Perforce           *

2010.2 (command-line client)

Note: The Perforce client must match your operating system. For example, if you are running Windows 7 64-bit, then you must use the 64-bit Perforce client.

Serena PVCS         *

5.2 and later

Note: PVCS 6.6.1 and 6.8.0 are specifically not supported with Team Coding.

Serena PVCS Version Manager:

  • PVCS is supported with Team Coding for both 32-bit and 64-bit SQL Navigator.
  • It has been tested with Serena PVCS Version Manager 8.5/ 8.4, and replaces existing Merant PVCS interfaces.
  • PVCS Version manager Command Line Interface (CLI) is supported.
  • PVCS Command Line option must be included when installing PVCS

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