Network import with DataPump

With DataPump, there is no need to create an export file anymore, if the sole purpose is to import data.

 

Before proceeding with the import, the following needs to be configured:

 

  • Create a streams pool (50Mb)
  • Create a directory (Since there is no export file involved, it serves as the location of the datapump logfile, there is no export file involved)
  • Grant read-write privileges on the datapump directory to the datapump user
  • Create a public database link to the remote database

 

Import with DataPump

Generic Example: (in this case I connected to the remote schema directly)

 

  1. alter system set streams_pool_size=50Mb scope=both;
  2. create directory DATAPUMP_DIR as ‘/export/datapump’;
  3. grant read, write on directory DATAPUMP_DIR to DPEDEV;
  4. create public database link RDPEPRD connect to DPEPRD identified by DPEPRD using ‘rdpeprd’;
  5. impdp dpedev/dpedev directory=datapump_dir network_link=RDPEPRD REMAP_SCHEMA=DPEPRD:DPEDEV

 Make sure the remote user has the EXP_FULL_DATABASE role

Pierre

Advertisements

4 thoughts on “Network import with DataPump

  1. Hi,
    Is there a logic behind creating strams pool to 50M or can it be higher or lower ???
    Also, do you need to create all users and TS ??
    I have a 2T db which I need to migrate to another server.
    Thinking of using network_link. What are your thoughts on this ?

  2. Hi Karnash,
    I would not attempt to import 2Tb through network_link. There are several issues with some datatypes and records length. In any case, you can try it in a testing environment, you might find workarounds for any bugs that could occur.
    Best practice call to duplicate the database through RMAN or copy the datapump file locally on your target database.
    Best of Luck, Pierre

  3. Hi,
    With EXPDP and IMPDP you have the option of exporting and importing tablespaces (TABLESPACES clause) and creating the users automatically (REMAP_SCHEMA clause).
    expdp … tablespaces=…
    impdp tablespaces=… remap_schema=SCOTT:SCOTT (this will create the user SCOTT in the database).

    P.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s