Using exp and imp for Oracle Database when switching platforms

Initially I had my Oracle 9i database on a Windows XP machine. I need to establish this particular database in Linux AS4 (Redhat) OS. I have configured the Oracle Database in the Linux machine. Can I import a dump from the previous Windows machine to this Linux machine and establish the database, or do I need to follow extra steps?

    Requires Free Membership to View

    Login

Since you are switching platforms (Windows to Linux), you will want to use exp and imp to perform the move. Perform a FULL export of your 9i database on Windows with exp. Then FTP the dump file (in BINARY mode!) to the Linux server. Precreate an empty database on the Linux server. Also precreate any tablespaces you'll need. Then perform a full import. It's as simple as that!

This was first published in July 2008

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top