All geek questions in one place

I want to create DDL for the whole schema in oracle 10 G?

I am using Oracle 10G.

I am new to oracle, I am a little versed in dbms_metadata.get_ddl, now using this utility, I want to create DDL for my whole scheme.

I mean, what DDL operations were performed on my schema (testschema).

Please help me.

thank

Nash.

+3
source share
4 answers

Have a look at EXPDP. This can lead to the complete export of all objects (with or without data) in the schema.

If this is a pretty “simple" scheme (without exotic objects and dependencies), you could script something based

SELECT DBMS_METADATA.GET_DDL(object_type, object_name) FROM user_objects
+1
source

oraddlscript, GET_DLL() , .

+1
source

A very simple way is to create a new empty schema, compare the existing testchema with it using Schema Compare for Oracle , and click the Deploy button to automatically create the DDL.

0
source

Source: https://habr.com/ru/post/1748465/

More articles:


All Articles