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.
D is correct
Why?
D is correct. Why? Cause I tested it 🙂 It can create more than 3 files because you say that each file has a maximum of 400 MB . For example in my export that had 1,2 gb it created 4 files. %u makes 01, 02, 03 and so on.
Example : full101.dmp, full102.dmp… full201.dmp, full202.dmp, full203.dmp and so on.
Thanks Vonpire but what about differenct locations?
B. Thanks Vonpire!
I mean D
BTW log file is created in default data_pump_dir directory with job_name.log , in this case expfull.log.
D
D
What about dump file where is it created?
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.
Correct Ans is D.
Logfile by default created in DATA_PUMP_DIR.
if you have cloned your database then you need to recreate the DATA_PUMP_DIR correctly
if you have created your database manually then ensure to create physical directory dpump before executing the exort.
SYS@ORCL> create directory dpump_dir1 as ‘D:\EXP\ORCL’;
SYS@ORCL> create directory dpump_dir2 as ‘D:\EXP\ORCL’;
SYS@ORCL> create directory dpump_dir3 as ‘D:\EXP\ORCL’;
SYS@ORCL> select directory_name, directory_path from dba_directories where directory_name=’DATA_PUMP_DIR’;
DIRECTORY_NAME DIRECTORY_PATH
——————– ———————————–
DATA_PUMP_DIR C:\app\oracle/admin/ORCL/dpdump
C:\Users\10>expdp SYSTEM FULL=YES DUMPFILE=dpump_dir1:fulll%U.dmp,dpump_dir2:full2%U.dmp,dpump_dir3:full3%U.dmp FILESIZE=400M PARALLEL=3 JOB_NAME=expfull
Password:
Starting “SYSTEM”.”EXPFULL”: SYSTEM/******** ….
Estimate in progress using BLOCKS method…
Total estimation using BLOCKS method: 522.8 MB
…
Master table “SYSTEM”.”EXPFULL” successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.EXPFULL is:
D:\EXP\ORCL\FULLL01.DMP
D:\EXP\ORCL\FULL201.DMP
D:\EXP\ORCL\FULL301.DMP
Job “SYSTEM”.”EXPFULL” completed with 68 error(s) at Fri Mar 31 21:59:05 2017 elapsed 0 00:02:53
D