本帖最后由 hlwjxsg 于 2012-6-19 10:59 编辑
sql脚本代码: call.sql
set echo off
set term off
set line 1000 pages 0
set feedback off
set heading off
spool C:\ldr_object.csv
@C:\getobject.sql
spool off
set heading on
set feedback on
set term on
set echo on
获取数据对象的sql getobject.sql
select a.owner||',"'||a.object_name||'",'||a.object_id||','||
to_char(a.created,'yyyy-mm-dd hh24:mi:ss')||','||a.status
from dba_objects a,(select rownum rn from dual connect by rownum<=20) b;
通过执行生成的 140 多万的数据 如下:
语句: sql>@c:\call.sq
我要导入的表结构:
SQL> desc scott.objects
Name Null? Type
----------------------------------------- -------- ---------