Which three are prerequisites for successful execution …

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:
In this case we have run the impdp without performing any conversion if endian format is
different then we have to first perform conversion.



Leave a Reply 1

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