SourceForge Logo

OraSchemadoc: Oracle Schema Documentation Generator



Dia diagram example


Project Summary




Goal of oraschemadoc is "JavaDoc" style detailed documentation for all objects in schema covering Oracle specific features. Result of execution of oraschemadoc is set of static html files.
See example output here.
Also it is possible to export datamodel to Dia UML Diagram.
See example here.


  • Python , version 2.0 or later.
  • Oracle Server , version 8.1.6 or later.
  • Oracle Server Client (see supported versions by cx_Oracle)
  • cx_Oracle - a Python extension module that allows access to Oracle
  • OS independ, in other words will run even on Windows :-)

Current Features

Currently OraSchemaDoc prints:
  • data about all tables, including columns
  • table constraints(check, unique and referential)
  • indexes, including functional and domain indexes
  • views
  • PL/SQL triggers, procedures, functions, packages
  • Sanity check - report about missed indexes on foreign key columns, and automaticaly generated sql file with defenition of missed indexes.
  • Export datamodel to Dia UML diagram.

Coming in the next releases

  • Clusters
  • Materialized views
  • Partition info for indexes and tables
  • Schema sanity check, more functionality
  • .....

Project news

OraSchemaDoc v0.25 released

* export datamodel to dia uml diagram! * bug fixes

OraSchemaDoc v0.24 released
Date: 2002-06-04

* support for sequences and java sources
* various bug fixes

OraSchemaDoc v0.22 released
Date: 2002-06-04

* fixed bug related to constraints on views

OraSchemaDoc v0.21 released
Date: 2002-06-03

* few bugfixes
* added verbose parameter. Should be used when sending bug reports or support requests

OraSchemaDoc v0.20 released
Date: 2002-05-19

* PL/SQL triggers, procedures, functions, packages
* Sanity check - check form foreign key without appropriate indexes
* Cleaner html output

OraSchemaDoc v0.11 released
Date: 2002-04-12

* fixed bug with frames and Netscape4
* check for output directory existence
* Changed description of name parameter

OraSchemaDoc v0.10 released
Date: 2002-04-11

OraSchemaDoc now shows:
* Tables
* Constraints
* Indexes
* Views

Aram Kananov
Last modified: Wed Sep 18 20:14:08 CEST 2002