Transfer Oracle database
hi,i wanna transfer my oracle database like tables from one server to another server using export and import command.
Software/Hardware used:
Software/Hardware used:
ASKED:
October 15, 2008 7:01 AM
UPDATED:
October 15, 2008 5:30 PM
RELATED QUESTIONS
- What is the best way to transfer data from an Oracle 9i database to a Lotus 6.5 database?
- Transferring a database from Microsoft Access to SQL Server 2000
- Connecting to SQL Server from an Oracle procedure
- Transferring a database and writing a database script in SQL Server 2008
- Develop Oracle application by 4GL
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
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.