sql 导出建表语句

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

2009-02-19 00:41:20|  分类： Oracle |  标签： |举报 |字号大中小 订阅

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