Re: Can you import an Oracle 10G database into a 9I database

On Mon, 16 Apr 2007 20:27:32 +0200, Frank van Bortel <frank.van.bortel_at_gmail.com> wrote:

>cboerman_at_comcast.net schreef:
>> Good afternoon,
>>
>> I am curious if it is possible to import an Oracle 10g database into
>> an oracle 9i instance. Any suggestions/thoughts?
>>
>> Thanks,
>> Chris Boerman
>>
>
>Of course. It's called downgrading.
>
>Or, if you do not want to downgrade, only if you're:
>1) skillful
>2) lucky
>
>You must be lucky, or I would not be answering this.
>Ever read the "New Features since 9i" chapters on 10G?
>Why do you think these are called "new"?
>
>So, export, using the 9i tool - if you're lucky, that works.
>Import, using the 9i tool - if you're lucky, that works.

I don't see why there should be so much 'luck' involved. I've done this back in 8->7.3.4 days, and I wouldn't think the process has changed much.

If I recall correctly, you need to run catexp from 9i on 10g database and then use the 9i exp binary to do the actual export.

-Andrey
.......
We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc) remove NSPAM to email Received on Mon Apr 16 2007 - 16:04:45 CDT