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.