How To Perform a Full Export And Exclude Certain Schemas Using The Data Pump API? [ID 1340781.1]

本文详细介绍了如何利用DataPump API(dbms_datapump)进行完整的数据库导出操作,并排除特定的模式。通过示例环境展示了如何在数据库中排除‘SYSTEM’和‘SCOTT’模式,确保导出过程的灵活性。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

 

9876
 

ID

 
 
单击此项可添加到收藏夹
转到底部转到底部

2011-7-23HOWTOMODERATED3
没有任何注释注释 (0)
为此文档评级
通过电子邮件发送此文档的链接在新窗口中打开文档可打印页

In this Document
  Goal
  Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.

Goal

You want to perform a full export and exclude certain schema(s) using the Data Pump API (dbms_datapump).
The next example demonstrates how to perform this operation.

In this example,  you have the following environment, you have 20 schemas in your database:

SQL> select username from dba_users;

 

9876
 

ID

 
 
单击此项可添加到收藏夹
转到底部转到底部

2011-7-23HOWTOMODERATED3
没有任何注释注释 (0)
为此文档评级
通过电子邮件发送此文档的链接在新窗口中打开文档可打印页

In this Document
  Goal
  Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.

Goal

You want to perform a full export and exclude certain schema(s) using the Data Pump API (dbms_datapump).
The next example demonstrates how to perform this operation.

In this example,  you have the following environment, you have 20 schemas in your database:

SQL> select username from dba_users;

In this Document
  Goal
  Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.

Goal

You want to perform a full export and exclude certain schema(s) using the Data Pump API (dbms_datapump).
The next example demonstrates how to perform this operation.

In this example,  you have the following environment, you have 20 schemas in your database:

SQL> select username from dba_users;

USERNAME
------------------------------
SYSTEM
SYS
MGMT_VIEW
SYSMAN
DBSNMP
TESTUSER
SCOTT
OUTLN
SI_INFORMTN_SCHEMA
ORDPLUGINS
XDB
WMSYS
EXFSYS
ANONYMOUS
ORDSYS
MDSYS
TSMSYS
ORACLE_OCM
DIP
MDDATA

20 rows selected.


You want to export the entire database but want to exclude the SYSTEM and SCOTT only while using the DataPump API.

To perform this operation from the command line for the data pump export (expdp) looks like:
expdp system/passwd directory=DATA_PUMP_DIR dumpfile=EXPDAT%U.DMP FULL=y exclude=schema:\"IN \(\'SCOTT\',\'SYSTEM\')\"




Solution

The equivalent operation using the Data Pump API PL/SQL code to perform the same operation would looks like:

connect system/passwd
declare
h1 number; -- Datapump handle
dir_name varchar2(30); -- Directory Name

begin
dir_name := 'DATA_PUMP_DIR';
h1 := dbms_datapump.open(operation =>'EXPORT',
job_mode =>'FULL',
job_name =>'FULL MINUS SCHEMAS',
version => 'COMPATIBLE');

dbms_datapump.set_parallel(handle => h1, degree => 1);
dbms_datapump.add_file(handle => h1,
filename => 'EXPDAT.LOG',
directory => dir_name,
filetype => 3);

dbms_datapump.set_parameter(handle => h1,
name => 'KEEP_MASTER',
value=> 0);

dbms_datapump.add_file(handle => h1,
filename => 'EXPDAT%U.DMP',
directory => dir_name,
filetype => 1);

dbms_datapump.set_parameter(handle => h1,
name => 'INCLUDE_METADATA',
value => 1);

dbms_datapump.set_parameter(handle => h1,
name => 'DATA_ACCESS_METHOD',
value => 'AUTOMATIC');

dbms_datapump.metadata_filter(handle => h1,
name => 'NAME_EXPR',
value =>'NOT IN(''SCOTT'',''SYSTEM'')',
object_type => 'SCHEMA');

dbms_datapump.set_parameter(handle => h1,
name => 'ESTIMATE',
value =>'BLOCKS');

dbms_datapump.start_job(handle => h1,
skip_current => 0, abort_step =>0);
dbms_datapump.detach(handle => h1);

end;
/


Upon review of the export log file (EXPDAT.LOG), you will be able to see from that the export excluded the SYSTEM and SCOTT schemas from the full export.

资源下载链接为: https://pan.quark.cn/s/22ca96b7bd39 在当今的软件开发领域,自动化构建与发布是提升开发效率和项目质量的关键环节。Jenkins Pipeline作为一种强大的自动化工具,能够有效助力Java项目的快速构建、测试及部署。本文将详细介绍如何利用Jenkins Pipeline实现Java项目的自动化构建与发布。 Jenkins Pipeline简介 Jenkins Pipeline是运行在Jenkins上的一套工作流框架,它将原本分散在单个或多个节点上独立运行的任务串联起来,实现复杂流程的编排与可视化。它是Jenkins 2.X的核心特性之一,推动了Jenkins从持续集成(CI)向持续交付(CD)及DevOps的转变。 创建Pipeline项目 要使用Jenkins Pipeline自动化构建发布Java项目,首先需要创建Pipeline项目。具体步骤如下: 登录Jenkins,点击“新建项”,选择“Pipeline”。 输入项目名称和描述,点击“确定”。 在Pipeline脚本中定义项目字典、发版脚本和预发布脚本。 编写Pipeline脚本 Pipeline脚本是Jenkins Pipeline的核心,用于定义自动化构建和发布的流程。以下是一个简单的Pipeline脚本示例: 在上述脚本中,定义了四个阶段:Checkout、Build、Push package和Deploy/Rollback。每个阶段都可以根据实际需求进行配置和调整。 通过Jenkins Pipeline自动化构建发布Java项目,可以显著提升开发效率和项目质量。借助Pipeline,我们能够轻松实现自动化构建、测试和部署,从而提高项目的整体质量和可靠性。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值