Re: Importing from 10g to 9?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 08 Mar 2005 22:36:16 +0100
Message-ID: <vf6s215ql9urun16i9ilualvkc679f48g6@4ax.com>

On 8 Mar 2005 12:23:08 -0800, "deanbrown3d_at_yahoo.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

The tric you need is
either
- to read the Oracle Server Utilities Manual - to query the groups archives at groups.google.com preferably prior to posting, as this is a FAQ (Most people do the same thing like you)

So for the umpteenth time
You need the lower version exp to connect to the higher version database. This has applied to all versions since Oracle 5.

So in your case, the 9i exp against the 10g database. THAT is the only 'trick' you need, and as it is the proper procedure, it is not a tric.

--
Sybrand Bakker, Senior Oracle DBA

Received on Tue Mar 08 2005 - 15:36:16 CST