set heading off
set echo off
set feedback off
set pages 10000
spool stop_index_monitor.sql
select dbms_metadata.get_ddl('TABLE',u.table_name) from user_tables u;
spool off
set heading on
set echo on
set feedback on
set echo off
set feedback off
set pages 10000
spool stop_index_monitor.sql
select dbms_metadata.get_ddl('TABLE',u.table_name) from user_tables u;
spool off
set heading on
set echo on
set feedback on
你写的 东东 是什么?
要怎么用?用 pl/sql developer 导出时,我的表里有大字段,总是报不能导出!
imp system/manager file=c:\a.dmp ow log=c:\a.log建表语句在a.log里面,sqlserver不支持varchar2数据类型