ram_jetwani
07-15-2005, 02:25 AM
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.
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.