Ask the Expert

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?

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: