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.
Dig deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.