export oracle 8i database from unixserver

5 pts.
Tags:
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

Answer Wiki

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

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.

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
  • HolmanSAP
    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.
    20 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