How can I import an Oracle8i database dump to Oracle9i?

    Requires Free Membership to View

Take the dump file to your Oracle9i database server. If using FTP to transfer the dump file, then transfer in BINARY mode. You can use the 9i imp executable to perform the import, similar to the following:
imp userid=system file=my_dump.dmp full=y

This was first published in April 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

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