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

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.

---

SQL Developer -> Tools -> Database Export...

---

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

---

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.

---

A really simple way is to create a new blank schema, compare your existing schema (testschema) against this using Schema Compare for Oracle, and click on the Deployment button to generate the DDL automatically.