Developed procedure to generate create Script for schema objects

[ram_jetwani]

Hi All,
I have developed a procedure which will generate create scripts for the objects of the specified schema. This procedure will create different files for each type of object. The objects which included are as under:

1) Tables

2) Indexes

3) Constraints

4) Java Source

5) Procedures

6) Functions

7) Packages with body

8) Object Grants

9) Role Grants

10) System Grants

11) Synonyms

12) Views

13) Materialize view

14) Triggers

15) Sequence

16) Types

17) Comments on table columns


NOTE: This procedure will not generate creation script for procedures which are created using loadpsp command i.e. PSP converted into procedures.

This procedure will take care of order of creation of tables with parent-child relationship.

The procedure takes two arguments:
First, the directory path, where you want to create files to be generated
second, the name of the schema.

Any suggestions and errors are welcome.