| exp remotely vs. .dmp file drag & drop [message #124646] |
Mon, 20 June 2005 14:06  |
TLegend33
Messages: 203
Registered: March 2005
|
Senior Member |
|
|
I'm curious, which would be quicker? (Win2K OS)
Taking a full export from a database on a source machine with 1GB/RAM & older processor, then moving that .dmp file to the target machine over the network? (i.e drag & drop)
or...
Creating a value in tnsnames.ora so I can export the source database from the target machine with 8GB/RAM & newer processor?
Would there be any difference in speed between the file drag & drop vs. exporting over the network? (assuming of course all factors are identical for both scenarios)
Thanks!
|
|
|
|
| Re: exp remotely vs. .dmp file drag & drop [message #124660 is a reply to message #124646] |
Mon, 20 June 2005 16:48  |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
I have found that exporting using a TNS entry, even if the database is on the same machine, can be up to tenfold slower (but always slower) than doing an export with just a username and password.
An ftp of that file, or zipping the file, doing an ftp and then unzipping was much less time for me.
So, I would do the export locally and then copy the file and do not use a TNS entry for the export.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
