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博客

oracle对象备份