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;
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博客 ” ，链接：https://blog.itpub.net/28598517/viewspace-764559/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
oracle对象备份
下一篇：
hadoop安装
请登录后发表评论
登录
全部评论
