Which statement is true about the execution of the command?

Examine the command: $expdp SYSTEM FULL=YES
DUMPFILE=dpump_dir1:fulll%U.dmp, dpump_dir2:full2% U.dmp, dpump_dir3:full3%U.djnp
FILESIZE=400M PARALLEL=3 JOB_NAME=expfull Which statement is true about the
execution of the command?

Examine the command: $expdp SYSTEM FULL=YES
DUMPFILE=dpump_dir1:fulll%U.dmp, dpump_dir2:full2% U.dmp, dpump_dir3:full3%U.djnp
FILESIZE=400M PARALLEL=3 JOB_NAME=expfull Which statement is true about the
execution of the command?

A.
It fails because the log file parameter is not specified.

B.
It fails because no absolute path is specified for the log file and dump file.

C.
It succeeds and exports the full database, simultaneously creating three copies of dump
files at three different locations.

D.
It succeeds and exports the full database, simultaneously creating three dump files at
three different locations, but the total number of dump files can exceed three.



Leave a Reply 3

Your email address will not be published. Required fields are marked *


ENSILVA

ENSILVA

If you run the command the way it is will not work, because you need to specify the directory parameter, it is required, I tested and prove that it did not work. To work needed to specify the directory, I believe it is to log generation.

Here evidence.

[oracle@localhost dump1]$ expdp SYSTEM FULL=YES DUMPFILE=dpump_dir1:full%U.dmp,dpump_dir2:full2%U.dmp,dpump_dir3:full3%U.dmp FILESIZE=50M PARALLEL=3 JOB_NAME=expfull

Export: Release 12.1.0.2.0 – Production on Mon May 30 22:07:52 2016

Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
Password:

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at “SYS.UTL_FILE”, line 536
ORA-29283: invalid file operation

Now adding the directory parameter can prove it works as follows:

[oracle@localhost dump1]$ expdp SYSTEM FULL=YES DUMPFILE=dpump_dir1:full%U.dmp,dpump_dir2:full2%U.dmp,dpump_dir3:full3%U.dmp FILESIZE=50M PARALLEL=3 JOB_NAME=expfull directory=DPUMP_DIR1

Export: Release 12.1.0.2.0 – Production on Mon May 30 22:09:33 2016

Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
Password:

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

WARNING: Oracle Data Pump operations are not typically needed when connected to the root or seed of a container database.

Starting “SYS”.”EXPFULL”: sys/******** AS SYSDBA FULL=YES DUMPFILE=dpump_dir1:full%U.dmp,dpump_dir2:full2%U.dmp,dpump_dir3:full3%U.dmp FILESIZE=50M PARALLEL=3 JOB_NAME=expfull directory=DPUMP_DIR1
Estimate in progress using BLOCKS method…
Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
Total estimation using BLOCKS method: 5.578 MB
. . exported “WMSYS”.”WM$CONSTRAINTS_TABLE$”
……………………

Thus, the best answer is B.

Maxim

Maxim

Tested and it worked as described in D, because user is SYSTEM and
http://docs.oracle.com/database/121/SUTIL/GUID-EEB32B50-8A00-40B0-8787-CC2C8BA05DC5.htm#SUTIL819
..Data Pump attempts to use the value of the default server-based directory object, DATA_PUMP_DIR. This directory object is automatically created at database creation or when the database dictionary is upgraded.
I found log under DATA_PUMP_DIR, named ‘export.log’.
If your DATA_PUMP_DIR does not exist or lacks permissions, command will fail.