Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

question about using datapump remotely with transportable tablespace

666678Oct 16 2009 — edited Oct 19 2009

Greetings,
Earlier I had posted a question on using datapump with transportable tablespaces and with the help of this forum I was able to get the right syntax to allow me to run the expdp on serverA and then run impdp on serverB. Both servers are on our corp network and both running 10gr2.

Now I need to try and automate this process and was hoping I could run the expdp command on serverB (target database) to run all my commands from one server.
Initially I tired running the same expdp command just with a username@REMOTEDB option but it didn't seem to work (no errors, no feedback either and no files).
Example (on serverB):
expdp userx@REMOTEDB transport_tablespaces=USERS dumpfile=users_tbs.expdp directory=dpump_dir1

After doing some reading it appears I should be able to the use the NETWORK_LINK option? I created a database link in my target database but the expdp command gives me an error "ORA-39200: Link name "XXXX" is invalid."
My command is:
expdp userx transport_tablespaces=USERS dumpfile=users_tbs.expdp directory=dpump_dir1 network_link=XXXX

On my source database I granted exp_full_database to account userx.
I can verify my connection via sqlplus userx@REMOTEDB.
Both databases have dpump_dir1 set the same.

So can I perform a transportable_tablespace export via datapump on a remote server as I want and am I on the right track or not?

Mark