set pagesize 0 set long 90000 select dbms_metadata.get_ddl('TABLE', table_name, '{owner}') from all_tables where owner='{owner}';