Example 3-3 performs a network-mode import where the source is the database specified by the NETWORK_LINK parameter.
"NETWORK_LINK" for more information about database links
Example 3-3 Network-Mode Import of Schemas
> impdp hr TABLES=employees REMAP_SCHEMA=hr:scott DIRECTORY=dpump_dir1 NETWORK_LINK=dblink
This example imports the employees table from the hr schema into the scott schema. The dblink references a source database that is different than the target database.
To remap the schema, user hr must have the DATAPUMP_IMP_FULL_DATABASE role on the local database and the DATAPUMP_EXP_FULL_DATABASE role on the source database.
REMAP_SCHEMA loads all the objects from the source schema into the target schema.