Freeware

From Oracle FAQ

List of Oracle Freeware products available in alphabetical order:

Please create separate wiki pages for product reviews that is longer than a paragraph or two. Leave an introductory paragraph and link to the new article on this page.

Adept For Oracle

A free program that can automatically back up most Oracle databases to local storage. Provides for automated hot backups and exports using a scheduler. The Adept for Oracle client must run on a Windows based PC but the database can be hosted on any type of server as long as the PC can map a drive to the database server. A subscription option allows the backups and exports to be automatically copied to a secure offsite storage location.

Aqua Data Studio

Aqua Data Studio is a FREE SQL editor and developer tool that allows developers to easily create, edit, and execute SQL scripts, as well as browse database structures.

CmdEmail

There is a simple and effective way to send email through oracle form, using the command line send mail component -- CmdEmail.

CmdEmail is a command line e-mail component, it can be integrated into your application developed by Oracle Form Builder, VC, VB, Perl etc.

Data Dictionary for Oracle

Data Dictionary for Oracle v1.1, a freeware tool for viewing DBA_View information. Use this application to reference Oracle 9.i2 documentation or connect to your own Oracle instance to obtain descriptions and column data from a live system.

DBAShell

DBA Shell Functions and Scripts to make it easy for common Database command-line chores such as assigning Environment variables, running scripts into logs, provide stored passwords, error checking, checking for db status, database restarts, compile, etc.

Free PLSQL Editor/Compiler/Object Viewer

I would like to share this wonderful free product with other members on this forum. Developed by Aleksey Kochetov, I have been using it with Oracle versions 8,8i and now 9i with no problems. You can also send him ideas for improvement or new features. It is always being improved. The product can be downloaded for free at the url given above.

Gold Fish.Net

Gold Fish.Net is a Charityware tool with such features as schema browser, storage manager, and export module. Through an easy to use interface you can edit, modify, create and drop most database objects.

HammerOra

Hammerora is a load generation tool for Oracle 8i, 9i and 10g on Linux/UNIX and Windows written in TCL/TK released under the GNU Public License. Therefore with Hammerora there is no expensive per "Virtual User" licensing. You can create the desired number of sessions that your hardware will sustain.

MyGeneration Development Tool

MyGeneration is a Developer Tool written in .NET that can create Oracle Stored procedures and Business Entities for your Oracle Application in seconds, it's 100% free

Odat, free Oracle Admin Tool

Most of us DBAs have a huge collection of SQL scripts for database monitoring purpose. The "twist" is how you can find the right script when you need it without digging folders after folders. Odat currently has about 100 most used scripts that generate a multitude of information for 8,8i,9i databases. All those scripts was tied together in a small panel with just a mouse click.

Oracle Tool

OracleTool is a Free powerful tool dedicated to the management and the tuning of Oracle Databases. It allows developers and DBA to easily edit all type of objects from Oracle Databases. Endow with a powerful PL/SQL EDITOR, tuning and statistics functions, OracleTool is enable to manipulate data (Filters, sorts, import and export). OracleTool is fully compliant with Oracle 10G & SQL+ GUI: French, English, Spanish and German New release : 2.3.0

OraEdit

A FREE editor for Oracle PL/SQL code with intelligent code completion, syntax coloring and much more.

OraSentry

OraSentry is a "Charityware" that allows you to monitor continuously Oracle databases' Alert.log files.

OraSnap (Oracle Snapshot)

OraSnap is a utility that gathers performance information from an Oracle v7.3.x, v8.x, v9.x database. These scripts can aid in tuning and optimizing your database. Output can be viewed from a Web Browser.

Pretoria

Pretoria is a tool for manipulating Oracle indexfiles. Basically, Pretoria parses the indexfile and performs a search and replace on the storage parameters - it then separates table create statements and index create statements.

RRDORA

Trendanalysis on Oracle database with RRDTool.

Schema graphical editor

Database Organizer is an web schema editor with functionality related to performance analyzation, sql builder, etc.

SchemaSpy

Simple command line tool which generates HTML reports of oracle DB schema, including UML diagrams showing relationships. A little fiddly to set up. Free & Open Source

SchemaSurf

SchemaSurfTM is a browser-based tool for querying your Oracle database schemas. Unlike most other tools, SchemaSurf does not rely upon SQL*Net and, therefore, can be accessed from anywhere in the world. SchemaSurf allows users to browse objects, view definitions, pull existing data (to both screen and spreadsheet), and extract by copy PL/SQL program units.

SoftTree SQL Assistant

SQL Assistant equips Oracle and SQL Server developers and DBAs with the productivity tools they need to speed up the database development process, improve code quality and accuracy.

SQL Developer

Oracle SQL Developer is a new, free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks.

SQLinForm

SQLinForm is an automatic SQL code formatter for all major databases (ORACLE, SQL Server, DB2 / UDB, Sybase, Informix, PostgreSQL, MySQL, etc) with many formatting options.

SQLTools

SQLTools is a light weighted and robust tool for ORACLE database development. It includes a text editor, an sql console and a couple of SQL utilities. You can use it for dial-up connection and it will work as fast as SQL*Plus.

The DDL Extract Wizard

The DDL Extract Wizard reads an Oracle export file and displays the DDL code contained within. The DDL can be written out as a series of SQL build scripts or as an interlinked HTML documentation tree. Rules can be applied which will globally modify optional DDL parameters such as tablespace names and storage clauses.

TSHSQL - PL/SQL Editor and SQL Query Tool

TSHSQL is a Java based PL/SQL editor and SQL query tool which works on any OS that supports a Java JRE (and an Oracle client installation for full OCI support).