nerdexam
Oracle

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.

Moving Data

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

1Z0-062 question #301 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)
  • A
    5% (1)
  • B
    11% (2)
  • D
    5% (1)
  • E
    79% (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.

AAdd network_link = devdb.us.oracle.com.

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.

BAdd the SYSTEM user to the schemas option.

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.

CChange the dumpfile option value to [email protected].

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.

DReplace the schemas option with network_1ink = devdb.us.oracle.com.

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.

EReplace the dumpfile option with network_1ink = devdb.us.oracle.com.Correct

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

#Oracle Data Pump#database link#schema import#data migration

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice