1Z0-062 · Question #301
You want to import the schema objects of the HR user from the development database DEVDB to the production database PRODDB by using Oracle Data Pump. A database link devdb.us.oracle.com is created bet
The correct answer is E. Replace the dumpfile option with network_1ink = devdb.us.oracle.com.. To perform a Data Pump network import, the NETWORK_LINK parameter must be specified, and it should replace the DUMPFILE parameter as data is transferred directly over the link, not from a file.
Question
You want to import the schema objects of the HR user from the development database DEVDB to the production database PRODDB by using Oracle Data Pump. A database link devdb.us.oracle.com is created between PRODDB and DEVDB. You execute the following command on the PRODDB database server:
What should you do to resolve the error?
Exhibit
Options
- AAdd network_link = devdb.us.oracle.com.
- BAdd the SYSTEM user to the schemas option.
- CChange the dumpfile option value to [email protected].
- DReplace the schemas option with network_1ink = devdb.us.oracle.com.
- EReplace the dumpfile option with network_1ink = devdb.us.oracle.com.
How the community answered
(19 responses)- A5% (1)
- B11% (2)
- D5% (1)
- E79% (15)
Why each option
To perform a Data Pump network import, the `NETWORK_LINK` parameter must be specified, and it should replace the `DUMPFILE` parameter as data is transferred directly over the link, not from a file.
Simply adding `network_link` without replacing `dumpfile` would likely result in an error or incorrect behavior, as these parameters are mutually exclusive for specifying the source of the import in a network import scenario.
Adding the `SYSTEM` user to the `schemas` option is irrelevant to resolving an error related to specifying the source of a network import; the `schemas` parameter defines which schemas to import, not how to connect to the source.
Modifying the `dumpfile` option with a database link syntax is not the correct approach for a network import; the `NETWORK_LINK` parameter is specifically designed for this purpose.
The `schemas` option specifies the schemas to be imported, while `NETWORK_LINK` specifies the source database link; these are distinct parameters with different functions, and one cannot replace the other.
When using Oracle Data Pump to import data directly from a remote database via a database link, the `NETWORK_LINK` parameter is mandatory to specify the connection to the source database. In this scenario, the `DUMPFILE` parameter is not used because no dump file is involved; data is streamed directly over the network link, so it must be replaced by `NETWORK_LINK`.
Concept tested: Oracle Data Pump network import with NETWORK_LINK
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/sutil/oracle-data-pump-utility.html#GUID-05990261-0F2C-4A00-8A7B-D577CCF828F7
Topics
Community Discussion
No community discussion yet for this question.
