How to get all DDLs for tables, views, Stored Procedures of a schema?

set long 20000000 pages 0 lines 131
column txt format a121 word_wrapped
spool c:\temp\txtable.txt
select ‘select dbms_metadata.get_ddl(”TABLE”,”’ || table_name ||”’,”SCHEMA_NAME”) from dual;’  from user_tables where table_name not like (more…)

This content is restricted to site members. If you are an existing user, please log in. New users may register below.

Existing Users Log In
 Remember Me  
New User Registration
*Required field