1Z0-067 · Question #225
Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source): $> impdp <user_name> full=Y network_link=hrdb_test transportable=always…
The correct answer is A. The impdp operation must be performed by the same user that performed the expdp operation. C. The export dump file must be created before starting the import on the target database. E. The import operation must be performed by a user on the target database with the. See the full explanation below for the reasoning.
Question
Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source):
$> impdp <user_name> full=Y network_link=hrdb_test transportable=always transport_datafiles= /u01/app/oracle/oradata/hrdb/sales01.dbf', /u01/app/oracle/oradata/hrdb/cust01.dbf', `/u01/app/oracle/oradata/hrdb/emp01.dbf', version=12 logfile=import.log Which three are prerequisites for successful execution of the command?
Options
- AThe impdp operation must be performed by the same user that performed the expdp operation.
- BThe path of data files on the target database must be the same as that on the source database.
- CThe export dump file must be created before starting the import on the target database.
- DAll the user defined tablespaces must be in read-only mode on the source database.
- EThe import operation must be performed by a user on the target database with the
- FThe source and target databases must be running on the same platform with the same
How the community answered
(36 responses)- A75% (27)
- B3% (1)
- D6% (2)
- F17% (6)
Community Discussion
No community discussion yet for this question.