Transfer Oracle database

5 pts.
Tags:
Oracle import/export
Oracle migration
hi,i wanna transfer my oracle database like tables from one server to another server using export and import command.
ASKED: October 15, 2008  7:01 AM
UPDATED: October 15, 2008  5:30 PM

Answer Wiki

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

Have a look at these links:
<a href=”http://www.orafaq.com/wiki/Import_Export_FAQ”>Import Export FAQ</a>
<a href=”http://www.psoug.org/reference/export.html”>Oracle Export Utility</a>
<a href=”http://www.psoug.org/reference/import.html”>Oracle Import Utility</a>

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: 1  Reply

 
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

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