Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Extract DDL for all objects separately !

AnkitVFeb 26 2013 — edited Feb 26 2013
Hi All

I have a huge DB having 3000 tables (having indexes,triggers,synonym), 1200 functions/procedures, 1000 views etc.
I need to extract only metadata and put into a version control repository.

I need to extract all objects (tables,procs,functions,views) in separate files, with the grants for each procs/func/table/view in the respective procs/func/table/view file only.
Indexes should be in respective table file only. Each object (procs/func/table/view etc) should have DROP command in the beginning.

I tried sql developer, but it gives separate files for grants,indexes,triggers,drops etc and also gives option to generate one script for all tables, one for all views, one for all indexes and so on, so doesn't satisfy my requirement.

Please suggest me a good tool (preferably FREE one) to extract the metadata in said fashion.

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 26 2013
Added on Feb 26 2013
16 comments
14,420 views