vi object.sql
set feedback off;
set heading off;
set pages 0;
set pagesize 50000;
set linesize 20000;
set sqlblanklines on;
set termout off;
set trimout on;
set trimspool on;
set verify off;
set long 100000;
set longc 1000000;
set heads off;
set echo off;
spool d:\new.sql;
select dbms_metadata.GET_DDL(case
when u.OBJECT_TYPE = 'PACKAGE BODY' then
'PACKAGE_BODY'
when u.OBJECT_TYPE = 'DATABASE LINK' then
'DB_LINK'
else
u.OBJECT_TYPE
end,
u.object_name) || ';'
from user_objects u
where u.object_type not in
('LOB', 'TABLE PARTITION', 'JOB', 'INDEX PARTITION');
spool off;
exit;
sqlplus cdw/cdw@cdw @object.sql
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28598517/viewspace-764558/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/28598517/viewspace-764558/