SourceForge Logo

OraSchemadoc: Oracle Schema Documentation Generator


Home

Example

Dia diagram example

Download

Project Summary

Forums/Support

Bugs

Overview

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.

Requirements

  • 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