Overview (Version 0.9.0.0)

The provided scripts will extract all sources from an Oracle schema and spool them into the filesystem in a specific structure. The scripts leverage the functionality of the Oracle Package DBMS_METADATA and thus will respect the specifics of later Oracle versions as well.

These scripts are used in different actual development projects for my clients. These are an important building block for my concepts related to configuration and lifecycle management of an Oracle APEX application, especially with regard to the SQL and PL/SQL related parts. These concepts and principles are described in chapter 9: Lifecylce Management from the book Expert Oracle Application Express.
Expert Oracle Application Express

How does it work?


1. Installation of required objects in the schema [application schema]

First of all we need to install a few objects into our application schema:
The installation procedures are described in detail on the installation page.

2. Extract the sources and store them in an intermediate table

The DDL for all objects from the connected schema [application schema] are extracted via the DBMS_METADATA package and stored in the table XLIB_DDL_STATEMENTS in the application schema.

3. Spool the objects into the filesystem using sqlplus

Using sqlplus the DDL statements from the table XLIB_DDL_STATEMENTS are spooled into the filesystem. The filesystem structure is initialized by the supplied ant script (build.xml), see http://ant.apache.org/ for details.

Directory Structure

This process can be influenced by

Current restrictions

We certainly use specific constraints in our projects, thus we have adapted the scripts to our needs and didn't implement a more generic. Our constraints are the following ones:

Enhancements / Further Development

Let me know what is working and what not, tell me your enhancement requests. Drop me a note at dietmar.aust@opal-consulting.de.