Navicat for Oracle 8.1.3

Navicat for Oracle 8.1.3 is a fast and powerful GUI tool lets you create, edit databases, run SQL queries and connect to remote Oracle in an easier way. Also, Navicat provides a number of tools allowing to perform all the necessary database operations such as creating, editing, and duplicating database objects. It also offers a well-described wizard system that simplifies your database development tasks. It supports Oracle 8i and later.

Major Features:

1. Oracle Objects Management              
   • Support Oracle servers 8i or above              
   • Create/drop schemas              
   • Support all Oracle objects: tables (Normal, External and Index Organized), views, stored procedures/functions              
   • Support all subobjects: fields, indices, foreign keys, uniques, checks and triggers Managing tablespaces, public database links and public synonyms              
   • Managing database links, indices, java, materialized views, materialized view logs, packages, sequences, synonyms, triggers, types, XML Schema and Recycle Bin     Support of physical attributes              
   • Support of character set and unicode              
   • Connection Management and Navigation              
   • Multiple local/remote Oracle server connections              
   • Support of Basic Connection              
   • Support of TNS Connection              
2. Connection to Oracle server through SSH
   
   • Multiple local/remote Oracle server connections  
     
   • Support of Basic Connection
     
   • Support of TNS Connection
     
   • Connection to Oracle server through SSH  
     
3. Data Viewer and Editor              
   • Grid view              
   • Form view              
   • TEXT, Hex and BLOB/BFile viewer/editor              
   • Copying and pasting selected records              
   • Customize display formats              
   • Incremental search, sorting and formatting table grid              
   • Ability to show/hide ROWID              
   • Support of foreign key data selection: locate the available values from the reference table              
   • Filtering Records              
   • Ability to set number of records showing on each page              
4. SQL Processing              
   • Visual query/view builder to facilitate the process of building complicated queue
   • Ability to create parameter queries              
   • Multiple SQL editors with syntax highlighted feature              
   • Code completion for SQL editors              
   • Ability to preview SQL before execution                          
   • SQL*Plus              
5. Diversified Import and Export Competence              
   • Importing data from ODBC: MSSQL etc              
   • Importing data from MS Excel                          
   • Importing data from other file formats : TXT, CSV, XML, DBF etc              
   • Exporting data to MS Excel                          
   • Exporting data to most popular formats: TXT, CSV, XML, DBF etc              
6. Other Data Manipulation Tools              
   • Data transfer              
   • Transfering data to SQL script as INSERT statement              
   • Transferring data to a SQL file with designated SQL format and encoding          
   • Data synchronization              
   • Structure synchronization              
7. Schedule for Batch Job              
   • Ability to set schedule on query execution, import/export, data transfer and data synchronization                          
   • Sending notification e-mail for schedule task              
   • Ability to attach Export Wizard/Report result files in Batch Job notification email
8. Server Security and Maintenance Services              
   • Visual user manager to administer users, roles and privileges              
   • Maintaining tables like Table Lock, Row Movement, Shrink Space, Table Move, Validate Table Structure and Collect Table Statistics              
   • Server Monitor to view and change system variables, to view server status information
9. Other Useful Features              
   • Empty/truncate tables              
   • Backing up schema/table to SQL script              
   • Executing SQL script              
   • Create table/view shortcut on desktop              
   • Print schema/table structure              
   • Support of docking/tab windows              
   • Support of virtual grouping: provide logical organization over connections and objects
   • Ability to run profile from command line              
   • Log files: keep track on the actions that have been performed in Navicat              
   • Ability to copy Connection Information into Clipboard     

Enhancements:

• Improvements:
• • Compatible with Mac OS X Snow Leopard.
  • Stability improvement on tabbed window.
• Bug Fixes: Import Wizard would be launched if the Data format was not properly set.

Requirements:

• Mac OS X 10.3 Panther, 10.4 Tiger or 10.5 Leopard
• Universal Binary