Importing dump file from Oracle on Linux to Oracle on Windows
How do you import a dump file from a Linux-based Oracle database into a Windows-based database? Can this also be done with compressed and split chunks?
The dump file from an Oracle export is platform independent. You can take that dump file to Linux, Windows, Unix, etc. If you are going to FTP the file to another server, make sure that you FTP the dump file in binary mode. Otherwise, you can corrupt the dump file.
You can compress and split the file, but you have to be careful on how you put the file back together and uncompress it. This is more commonly done in the Unix environments. I'm not sure if Windows has the utilities to put the split chunks back together.
This was first published in February 2004