Home > IT Answers > Database > export oracle 8i database from unixserver
Smmd
5 pts.
 export oracle 8i database from unixserver
Database, Oracle 8i, Windows XP
I have oracle 8i database on unixserver. How i able to export the entire database or schema to windows Xp. plz suggest

Software/Hardware used:
ASKED: January 4, 2008  9:53 AM
UPDATED: January 7, 2008  6:40 PM
RELATED QUESTIONS
Answer Wiki:
You should be able to shutdown the Oracle database on the unix server and copy the files to the Windows XP server (probably via FTP) then attach the database to the Oracle database installed on your workstation. If you can't shutdown the Oracle database then do a backup of the database and restore it on your machine. Or you can script out the objects in the Oracle Tools or via Toad for Oracle. You will need fairly high end rights to the Oracle database on the Unix server to do any of this.
Last Wiki Answer Submitted:  January 4, 2008  8:51 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

You will need to create an empty database on the Windows server. Following that, you will need to:
1) do a full database export with the Oracle export utility
2) use a zip utility in unix to compress the export file (if it is significantly large).
3) copy the compressed export file to your windows server.
4) use a windows unzip utility to unzip the file you just copied (if it was zipped)
5) use the Oracle import utility to load the (exported) file into the new database on your winodws server.

The Oracle database data files are not compatable between the systems, so you can’t just copy them over from Unix to the Windows server; however , the Oracle export utility does create a file that is binary compatible between the Unix and Windows server. Thus, you can copy the file containing te export from system to system.

HolmanSAP
 20 pts.