Which three are prerequisites for successful execution of the command?

Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source):

Which three are prerequisites for successful execution of the command?

Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source):

Which three are prerequisites for successful execution of the command?

A.
The import operation must be performed by a user on the target database with the
DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the
source database with the DATAPUMP_EXD_FULL_DATABASE role.

B.
All the user-defined tablespaces must be in read-only mode on the source database.

C.
The export dump file must be created before starting the import on the target database.

D.
The source and target database must be running on the same platform with the same
endianness.

E.
The path of data files on the target database must be the same as that on the source database.

F.
The impdp operation must be performed by the same user that performed the expdp operation.

Explanation:
A, Not F :The DATAPUMP_EXP_FULL_DATABASE and
DATAPUMP_IMP_FULL_DATABASE roles allow privileged users to take full advantage of the
API. The Data Pump API will use these roles to determine whether privileged application roles
should be assigned to the processes comprising the job.
Note:
* The Data Pump Import utility is invoked using the impdp command.
Incorrect:
Not D, Not E: The source and target databases can have different hardware, operating systems,

character sets, and time zones.



Leave a Reply 12

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


Ledeboer, Jeroen

Ledeboer, Jeroen

It’s A,B,E
C is wrong because you’re using a network expdp/impdp
D is wrong because you can convert endianness with rman, and multiple platforms transport is possible.
E is right, because else the clause would be: transport_datafiles=’source’,’destination’, for all datafiles.
Here are 3 datafiles, so this could never be the issue.

fj

fj

ABD

Serj

Serj

Agree (export dump even is not mentioned in the script)

Andrey

Andrey

AB ???

### Not D
If the source platform and the target platform are of different endianness, then you must convert the data being transported so that it is in the format of the target platform. You can use the DBMS_FILE_TRANSFER package or the RMAN CONVERT command to convert the data. See Oracle Database Administrator’s Guide for more information about using either of these options.
https://docs.oracle.com/database/121/SUTIL/dp_import.htm#SUTIL893

### Not E
Test:
http://oracleinaction.com/12c-transport-database-network/

### Not F
expdp is not needed.

Cihan Gedik

Cihan Gedik

Hi Andrey

impdp system/oracle full=y network_link=orcl_link transportable=always transport_datafiles=’/u01/app/oracle/oradata/dest/users01_orcl.dbf’,’/u01/app/oracle/oradata/dest/example01_orcl.dbf’ version=12 logfile=import.log

As Ledeboer, Jeroen said if the path is not same you should define target path as in the example in your link I think you missed it or Am I wrong ?

Amar

Amar

It will be ABD. C does not make sense since it is network link impdp which itself creates export dump on the fly and does not need an already present export dump file.

Ziad Abuqasem

Ziad Abuqasem

To transport the database over the network use import with the NETWORK_LINK parameter
The import is performed using the database link and there is “NO DUMP FILE INVOLVED”

This text pasted from oracle university book.
So the correct answer is ABD

Ziad Abuqasem

Ziad Abuqasem

sorry A , B and E
not D

max

max

ABD E is wrong because you copy the tablespace datafile from source to target before running the impdp command. In the impede command you use the structure of the target db to define the place of the datafiles. Therefore no need that the path is the same.

domq

domq

A B D,
A and B are obvious, but D because you transfer them over network, there aren`t such think as implicity endian conversion, if you want to do this you have to transfer them by copying them to remote host and then made conversion using RMAN