Home Products Navicat for Oracle For Linux

For Linux


Latest Oracle Versions Support
Additional Connection Options
Comprehensive Management of Oracle objects
Diversified Import and Export Competence
Powerful Data Manipulation Tools
Powerful Security Management
Well-Designed Visual Builder / Editor
More great features

System Requirements
  • Compatible with i386 PC
  • Supports 32-bit and 64-bit Linux platform
  • Supports Linux kernel version 2.2 or higher
  • Supports GNOME and KDE
Latest Oracle Versions Support

Navicat for Oracle - a powerful Oracle Database Server administration and development tool. Highlights of supported features:
- Support of Oracle versions from 8i or above
- Support of Multiple Connections to local or remote Oracle Server
- Support of Unicode / Character Set
- Support of Triggers and Foreign Keys
- Support of Views and Stored Procedures creation
- Support of Oracle Objects like Directory, Synonym and Materialized View

Additional Connection Options

Native Connection Options
Navicat for Oracle offers one connection mode to the Oracle server: connection through the Oracle Call Interface (OCI) in Basic 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.


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, public database links, public synonyms, database links, indexes, java, materialized views, materialized view logs, packages, sequences, synonyms, triggers, xml schemas, recycle bin and more.

SQL Preview
The SQL Preview area shows you SQL representation of the oracle objects you are creating. This ability allows you to preview SQL before execution.

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

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


Diversified Import and Export Competence

Import data from TXT, DBF, XML, etc

Import Wizard allows you to import data into a table from diverse format. On top of that, you can save your settings as an import profile for setting schedule.
Export data to Excel Spreadsheet, HTML, PDF, TXT, DBF, XML, etc
Likewise, Export Wizard allows you to export data into various format. Save your settings as an export profile for setting schedule.

Export data and create records as INSERT statements in sql file
During Data Transfer, you can choose to export data as sql file with record options like complete insert statements etc.


Powerful Data Manipulation Tools

Form View

Manipulate the current record with Form View. Enjoy a clear display of field name and its value with focus on current record.
Support of Foreign Key Data Selection
With the GUI tool - Foreign Key Data Selection, you can locate the foreign key values from the reference table. Stop shifting the view to a master table to look for the available values!

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.

Support of Data Transfer between local / remote Oracle schemas
Transfer tables/views/functions/procedures/functions/sequences from one Oracle schema to another, or to a plain text file.
Create Schedule for Import / Export, Data Transfer, Saved Queries and Data Synchronization
Create a batch job for setting schedule to execute at one or more regular intervals, beginning and ending at a specific date and time. Batch job can be created for Query, Data Transfer, Data Synchronization, Import and Export.

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

Powerful Security Management

Visual User Manager

Navicat provides users a visual tool for user management. You can easily add, duplicate, delete users, and edit global user privileges, and grant privileges on the selected databases, tables/views, fields and functions/procedures, etc.


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.

Query Editor
It allows you to create and edit SQL text for a query, prepare and execute selected queries.

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

Code-Completion for Query, View, Function 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.


More great features

Virtual Grouping

Have a better organization over objects in Navicat. You can categorize objects into groups with the Virtual Grouping feature. Virtual Grouping can be applied on Connection, Table, View, Function/Procedure, Query and Schedule.

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.

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, Backup, Import / Export etc.

Text / Blob View
Navicat provides Text / Blob Viewer and Editor to view and edit TEXT / BLOB fields content. The editor allows you to view, update, insert or delete data in a table.