I want to generate DDL for entire schema in oracle 10 G ?

Question

Hi Experts,

I am using Oracle 10G.

I am new to oracle, I have little bit regarding dbms_metadata.get_ddl, now using this utility i want to generate a DDL for my entire schema.

I mean what ever DDL operations done on my schema (testschema).

Please help me out.

Thanks

Nash.

Answer 1

Suggest you look into EXPDP. That can produce a full export of all the objects (with or without data) in a schema.

If it is a fairly 'plain' schema (no exotic objects and dependencies), you could script something based on

SELECT DBMS_METADATA.GET_DDL(object_type, object_name) FROM user_objects

Answer 2

Have a look at my command-line tool oraddlscript, which calls the GET_DLL() function for every object of a given user. The result can be written to one file per each object.