Oracle中使用SQL语句导出库中所有表的建表语句收藏

set heading off

set echo off

set feedback off

spool D:\myddl.sql

select DBMS_LOB.substr(DBMS_METADATA.get_ddl('TABLE',u.TABLE_NAME)) FROM USER_TABLES U;  

spool out

set heading on

set echo on

set feedback on