OCP 1Z0 052 103

来源：互联网发布：em10 mark iii 知乎编辑：程序博客网时间：2024/05/16 05:51

103. Which two statements are true regarding the Oracle Data Pump export and import operations?
(Choose two.)
A.You cannot export data from a remote database.
B.You can rename tables during an import operation.
C.You can overwrite existing dump files during an export operation.
D.You can compress the data during export but not the metadata because it is not supported.
Answer: BC

A 通过database link可以取remote database的数据
B 通过 REMAP_TABLE 参数
C 存疑

G:\Tools\Console2>expdp system/ofbiz directory=DATA_PUMP_DIR dumpfile=scott.dmp schemas='SCOTT';Export: Release 11.2.0.4.0 - Production on Tue Jun 17 14:48:15 2014Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsORA-39001: invalid argument valueORA-39000: bad dump file specificationORA-31641: unable to create dump file "D:\app\Administrator\admin\orcl\dpdump\scott.dmp"ORA-27038: created file already existsOSD-04010: <create> option specified, file already exists

参见
http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_datpmp.htm#ARPLS66027
Dump files will never overwrite previously existing files. Instead, an error will be generated.

D

COMPRESSION

Text

Export

Allows you to trade off the size of the dump file set versus the time it takes to perform export and import operations.

The DATA_ONLY option compresses only user data in the dump file set.

The METADATA_ONLY option compresses only metadata in the dump file set.

The ALL option compresses both user data and metadata.

The NONE option stores the dump file set in an uncompressed format.

The METADATA_ONLY and NONE options require a job version of 10.2 or later. All other options require a job version of 11.1 or later.

Default=METADATA_ONLY

0 0