PROMPT PROMPT~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ PROMPT------ /) (\ PROMPT------ .-._((,~~.))_.-, PROMPT------ `-. @@ ,-' PROMPT------ / ,o--o. \ PROMPT------ ( ( .__. ) ) PROMPT------ ) `----' ( PROMPT------ / \ PROMPT------ / \ PROMPT------ / \ PROMPT------ "The Silly Cow" PROMPT----- Script: ddl-objects.sql PROMPT----- Author: Prashant 'The FatDBA' PROMPT----- Version: V1.3 (Date: 04-12-2013) PROMPT----- PROMPT----- PROMPT----- SELECT 'SELECT dbms_metadata.get_ddl(''DB_LINK'',''' || db_link || ''',''' || owner || ''') FROM dual;' FROM dba_db_links WHERE db_link IN ('DB_LINK1', 'DB_LINK2','DB_LINK3'); select dbms_metadata.get_ddl('TABLE','&Table_Name','&Schema') from dual; select dbms_metadata.get_ddl('INDEX','&Index_Name','&Schema') from dual; SELECT DBMS_METADATA.get_ddl('CONSTRAINT', '&constraint_name', '&owner') from dual; SELECT dbms_metadata.get_ddl('PROCOBJ', '&job_name', '&owner') FROM DUAL; SELECT dbms_metadata.get_ddl('PROCOBJ', '&program_name', '&owner') FROM DUAL; SELECT dbms_metadata.get_ddl('TABLE', '&table_name', '&owner') FROM DUAL; SELECT dbms_metadata.get_ddl('VIEW', '&view_name', '&owner') FROM DUAL; SELECT dbms_metadata.get_ddl('MATERIALIZED_VIEW', '&MVIEW_NAME', '&OWNER_NAME') FROM DUAL; SELECT dbms_metadata.get_ddl('PACKAGE', '&pkg_name', '&owner') FROM DUAL; SELECT dbms_metadata.get_ddl('PROCEDURE', '&proc_name', '&owner') FROM DUAL; SELECT dbms_metadata.get_ddl('TYPE', 'type_name', '&owner') FROM DUAL;