Where to create directory for importing over network link?

Question

While using data pump import over network link in Oracle:

    impdp test/test@db10g tables=SCOTT.EMP network_link=REMOTE_SCOTT 
    directory=TEST_DIR remap_schema=SCOTT:TEST

Where are we creating directory object (TEST_DIR, for the above example)? On source or target database? Or both?

score 1 · Answer 1 · answered Jul 06 '12 at 20:12

1

impdp with network_link, TEST_DIR directory needs to be created at local. In your example where @db10g database is running.

answered Jul 06 '12 at 20:12

yahonda

1 Answers1