|
-
 Originally Posted by nir_s
PAVB - don't you think that running expdp/impdp from the target server is better than exp-compress-ftp-uncompress-imp?
Just to be clear, I'm not suggesting exp-compress-ftp-uncompress-imp.
What I've suggested is a three steps process, not a five steps process:
Step #1: Export/Compress on-the-fly in a single step.
Step #2: FTP compressed file
Step #3: Uncompress/Import on-the-fly in a single step.
The expdb over a NETWORK_LINK and them impdb will move uncompressed data over the network -which is probably your slower component- while proposed strategy will move compressed data.
I will love to see the results of a test, would you mind in testing both alternatives for a medium size table and post results?
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote