Re: Importing from 10g to 9?

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 8 Mar 2005 13:45:50 -0800
Message-ID: <1110318350.142803.126800@g14g2000cwa.googlegroups.com>

deanbrown3d_at_yahoo.com wrote:
> Hi there,
>
> We've had problems importing from 10g databases to 9. Is there some
> trick that we can do to allow this to occur smoothly? Conversion
> utility? The error message is IMP_00010 invalid header.
>
> THX
>
> Dean

Use lower version exp tool against the source database out of the two versions involved. (9i in your case)
Use target version imp tool against the target database out of the two versions involved. (9i in your case).
When ftping the export dump file, do it in binary mode.
Keep in mind that exp/imp tools are client utilities thus they use client NLS_LANG settings and not the database.

This is all documented.

Regards
/Rauf Received on Tue Mar 08 2005 - 15:45:50 CST