Transfer Oracle database

5 pts.
Tags:
Oracle import/export
Oracle migration
Hi, I want to transfer my Oracle database like tables from one server to another server using export and import command. How can I do that?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Have a look at these links:

You should also take a look at your Oracle Documentation, which contains a complete description and examples of import and export utilities.

If you have any specific questions, feel free to post them here.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

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
  • Randym
    If you want to transfer the exact set up of the database (i.e. same drive structure as far as drive letters and paths and the same version of Oracle) to a different server, you can first install Oracle using the installer; but do not install a database. This will set up the registry and program files. Then with the Oracle database shutdown and all Oracle services shutdown, you can copy the data files from one server to the other (again as long as the drive and path structure is the same) and Oracle will startup with no problems. The export/import method is supposed to work too; but I have had problems do and import of the entire file. Meaning system tables and the related things to system like database links.
    1,740 pointsBadges:
    report
  • Brijesh
    Hi,

    If one time transfer 

    • install the same version of Oracle on the second PC
    • create the same directory structure for the database files on the second PC

    • copy the database files (tablespace files, control files, redo logs) to the second PC (with the database shut down on PC #1!)

    or 

    The easiest way to transfer database structures (tables, packages, etc) together with data (or indeed without it) is to use the Oracle import/export utlities. As you're using Oracle 11g you should employ Data Pump for this. (On 9i or earlier it would be the old EXP and IMP utlities).

    Use Export (expdp) to make the dump file from your source PC. Transfer it to your target PC and use Import (impdp) to load it.

    At this point I would link to the documentation but the Oracle online docs are currently offline. So here's a link to the Oracle Wiki page instead: find out more.

    8,775 pointsBadges:
    report
  • Brijesh
    Hi,

    If a one-time transfer to another PC then:

    install the same version of Oracle on the second PC
    create the same directory structure for the database files on the second PC

    copy the database files (tablespace files, control files, redo logs) to the second PC (with the database shut down on PC #1!)     

    The easiest way to transfer database structures (tables, packages, etc) together with data (or indeed without it) is to use the Oracle import/export utlities. As you're using Oracle 11g you should employ Data Pump for this. (On 9i or earlier it would be the old EXP and IMP utlities).

    Use Export (expdp) to make the dump file from your source PC. Transfer it to your target PC and use Import (impdp) to load it.


    8,775 pointsBadges:
    report

Forgot Password

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

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

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

Thanks! We'll email you when relevant content is added and updated.

Following