Oracle 8i to Oracle 10g Export /Import

15 pts.
Tags:
Oracle 10g
Oracle 8i
Oracle import/export
Hi, Presently iam Exporting the Oracle Database of 8i version 8.1.6.0 on HP-UX to import on Oracle 10g 10.2.0.3 So my question is there is any need to apply 8i Patch before taking export i.e; from 8.1.6.0 to 8.1.7.4 this is the last & latest patch of 8i to support 10g so i want to ask you that it is necessary to apply the path even for using of export & import also as i am not Manually Upgrading the database so it is necessary to apply patch before export. Thanks in Advance........
ASKED: March 19, 2008  4:43 AM
UPDATED: June 26, 2008  8:24 PM

Answer Wiki

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

I’m not positive. Saw this <a href=”http://searchoracle.techtarget.com/expert/KnowledgebaseAnswer/0,289625,sid41_gci1192247,00.html”>question</a> which indicates that a direct upgrade to 10g release 2 is supported from 8.1.7.4 so I would guess that what you are trying with export/import from 8.1.6.0 would be possible.

I think it’s worth trying first. After you use the 8i export, the 10g import utility will complain if it can’t utilize the 8.1.6.0 export file.

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
  • BrentSheets
    For others interested in learning more about Exporting Oracle Data, this compliation of questions and answers, from Oracle experts Eli Leiba, Karen Morton and Brian Peasland explain more on export options, how it's done, with step-by-step instructions and example scripts, and talk about what can and cannot be exported.
    6,875 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