Database Utilities (MOSC)

MOSC Banner

In 11.2 can compression be used for Network Import?

edited Jan 25, 2018 4:01AM in Database Utilities (MOSC) 6 commentsAnswered
Hello Database Utilities community.

For years I have been successfully using Data Pump Import to copy all tables within a schema from a source database to a target database.  I have been using the DBMS_DATAPUMP package to achieve this.  On the target database, I perform what is apparently called a 'Network Import', specifying the name of a database link to the source database.  Using this technique, I need not perform an export as a separate step, nor do I create any intermediate .dmp files.  This work has been done with version 10.2.0.3

So far so good.

Now I am using version 11.2, and would like to take advantage of the new compression feature.  My primary goal is to reduce the time required to perform the operation.  My secondary goal is to reduce the amount of network bandwidth used.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center