EXP/IMP over SQLNet
I need to export and then import a 25G database. Due to security restrictions we need run the export and then the import from our desktop over SQLNet. Are there any tips on specific exp/imp parameter settings to optimize this process?
My first attempt has taken nearly 48 hours for the import. I set the buffer=100M. Is that too high for over SQLNet.
Alternatively we could use sftp to move dmp from one server to our desktop and then to the final destination but this is also is very slow. I know we could compress the dmp file but that also adds time. Are there parameters for sftp to speed things along?