 |
Features
|
System Requirements
- Microsoft Windows 2000, XP, Vista or 2003
- Pentium II processor or above
- 64 megabytes (MB) of RAM
- Hard-disk space vary depending on installation. Full installation requires 10 MB of available hard-disk space
|
 |
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 |
  |
| |
| |
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.
|
|
| |
 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
Schema / Table Structure
Present the schema / table definition by printing their structures
in Navicat. Understand the respective object structure fully
at a glance.
|
|
| |
| |
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/stored 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 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.
|
|
| |
| |
Powerful Security Management
|
 Visual User Manager
Navicat provides users a visual tool for user management. You can easily add, delete, edit users / roles, and grant privileges on the selected schemas, tables/views, fields and stored procedures. |
|
| |
| |
Easy-to-use Report Builder *only available in Windows Enterprise Version
|
 Create reports with visual Report Builder
Create different types of reports with our user-friendly GUI Report Builder. Design reports for Invoice, Statistics, Mailing Labels and more. |
|
| |
 Export report to multiple formats, PDF, Excel, HTML etc.
Enjoy more output formats for report export - text, pdf, Lotus, Excel, Graphic, Html and more. Check out the feature in Report Builder included in Navicat Enterprise Version. |
|
| |
 Backup
your report as archive file (.raf)
Navicat allows you to backup your reports as an archive file
(.raf) to increase portability. This file only stores data at
the time you backup. |
|
| |
| |
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, Stored Procedure, Query, Report 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.
|
|
| |
 SQL*Plus
To use a command-line interface, you can open SQL*Plus in Navicat. It provides you an interactive text-based screen to query input and result output from database. |
|
| |
 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.
|
|
| |
|
|
Native
Connection Options
Advanced Connection Options
Support
of SSH Tunnel
Export
Registry Record(.reg) via Navicat for Oracle
Import
data from ODBC
Import
data from up to 11 most popular formats including MS Access,
MS Excel, XML, HTML, TXT and CVS 
Export
Data to different file formats: TXT, CSV, DBF and XML 
Visual
Query / View Builder 
Query Editor 
Support of Parameter Query 
Code-Completion
for Query, View, Stored Procedure and oracle objects 