objects备份

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;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28598517/viewspace-764559/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28598517/viewspace-764559/