Multiple errors during impdp

[LKBrwn_DBA]

I do not have the write access to the source database from where I need to pull the tables. For the source database, I have the LDAP connection information.
. . . E t c . . .

First some definitions:
- Source db is the source of the tables to be copied
- Target db is your db where the tables are to be copied to
- Target server is the server on which the target db resides.

1) The DB Service from your LDAP connection should match the tns entry for the source database.

2) The DIRECTORY path can be defined in the db on target server (under below conditions)

3) Issue the impdp command on the target server similar to as follows:

C:>impdp example/example DIRECTORY=DATA_PUMP_DIR
NETWORK_LINK=db.legal.regn.net remap_schema=BI:example
tables=BI.BI_DIRECT logfile=BI.log

Where:
- DIRECTORY is created on target db as a local path
- NETWORK_LINK is a db link created in your target db

Note this:
i) You do not use the "@database_alias" if db on same server issuing the command.
ii) If you use network link you do not need a dump file.
iii) REMAP_SCHEMA option may not work for single partitions.

HTH