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? (Choose…

Question

Exhibit

Options

• AThe import operation must be performed by a user on the target database with the
• BAll the user-defined tablespaces must be in read-only mode on the source database.
• CThe export dump file must be created before starting the import on the target database.
• DThe source and target database must be running on the same platform with the same endianness.
• EThe path of data files on the target database must be the same as that on the source database.
• FThe impdp operation must be performed by the same user that performed the expdp operation.

• A
  82% (49)
• C
  2% (1)
• E
  5% (3)
• F
  12% (7)

Explanation

Start SQL*Plus and connect to the target database as the administrator who will transport the database with Data Pump import. This user must have DATAPUMP_IMP_FULL_DATABASE role to transport the database. During the import operation, the database link must connect to a user on the source database with DATAPUMP_EXP_FULL_DATABASE role. The user on the source database cannot be a user with SYSDBA administrative privilege. Make all of the user-defined tablespaces in the database read-only. The source database and target database are running on the same platform with the same

No community discussion yet for this question.