Additional Connection Options

Native Connection Options
Navicat for Oracle offers two connection modes to the Oracle server: connection through the Oracle Call Interface (OCI) in Basic mode and alias entry from a tnsnames.ora file in TNS mode.

Advanced Connection Options
You can set the role for user to connect with Default, SYSOPER or SYSDBA system privilege. Besides, you can pass control of user authentication to the operating system by means of OS authentication option.

Support of SSH Tunnel
Establish a secure SSH session through SSH Tunneling in Navicat. Enjoy a strong authentication and secure encrypted communications between two hosts. The authentication method can use a password or public / private key pair.

Export Registry Record(.reg) via Navicat for Oracle
You can easily transfer your connection settings while migrating Navicat from one computer to another new machine. Simply export a registry file via Navicat and restore it on the new machine.

Comprehensive Management of Oracle objects

Create, edit and drop table's fields, indexes, foreign keys, uniques, checks, triggers and privileges
With Table Designer - the basic Navicat for Oracle tool for working with tables, you can create, edit and drop table's fields, indexes, foreign keys, checks, triggers, privileges and much more.

Support of tablespace, package, sequence, synonym, trigger, type and more
Navicat allows you to create, edit and drop directories, tablespaces, publice database links, public synonyms, database links, indexes, materialized views, materialized view logs, packages, sequences, synonyms, triggesr and more.

Dump object definition as sql file
Backup object definition and data with ease by dumping as sql file.

Print Schema / Table Structure
Present the schema / table definition by printing their structures in Navicat. Understand the respective object structure fully at a glance.

Export Data to different file formats: TXT, CSV, DBF and XML
Likewise, Export Wizard allows you to export data into various format. Save your settings as an export profile for setting schedule.

Data and Structure Synchronization
You can transfer data from one Oracle schema to another with detailed analytical process. Likewise, you can compare and modify the table structures. For both Data and Structure Synchronization, the target schema can be on the same server as the source or on another server.

Send notification e-mail for schedule task
Generate notification e-mails to recipients you specify, connecting them to the latest schedule information. Read directly through your email account on the results returned from a schedule.

Well-Designed Visual Builder / Editor

Visual Query / View Builder
Visual Query / View Builder - which is divided into two portions: the upper Graphical View, and the lower Syntax View, allows you to create and edit queries / views visually without knowledge of SQL.

Support of Parameter Query
Set query parameters to add variable values to a query each time you run it.

Code-Completion for Query, View, Stored Procedure and oracle objects
Experience a quick way in constructing SQL statements in SQL Editor with the Code-completion feature. Whether you want to select available properties of database objects or SQL keywords, all it takes is a pick from the drop-down list.

Server Monitor
Select the servers that you want to monitor by checking them in the checklist box of the Server Monitor Window. Click on either Process List, Variables or Status Tab to show and/or modify the properties of Oracle servers.

Docking
You can customize your window behaviour style into Docking Windows or Floating Windows. Choose either dock the opened windows to the main window/dock windows or inherit the last docking style.

Profile System
For most of the tasks, Navicat allows you to save / load profiles to increase convenience. Profile can be applied on Data Transfer, Data / Structure Synchronization, Batch Job, Import / Export etc.