Extract DDL usando dbms_metadata

select 'select dbms_metadata.get_ddl(''TABLE'','''||object_name||''',''&&schema'')||chr(10)||''/'' from dual;' from dba_objects where owner = UPPER('&schema') and object_type = 'TABLE' and object_name not like 'BIN$%' --EXLUIR OS ITENS DA RECYCLEBIN (LIXEIRA DO ORACLE)