Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question
add comment

1 Answer

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

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.