Re: import 8i database into 7.3

raghu1ra_at_rediffmail.com (raghu) wrote in message news:<d11b9387.0201221136.794c4cf8_at_posting.google.com>...
> postbus_at_sybrandb.demon.nl (Sybrand Bakker) wrote in message news:<a20d28ee.0201220108.605894cf_at_posting.google.com>...
> > hassan_ayub_at_yahoo.com (Hassan Ayub) wrote in message news:<1df2b71.0201210839.46f6dce1_at_posting.google.com>...
> > > Hi there,
> > > Thanks a lot for you prompt reply, but what I'm talking about
> > > stand alone application, in which I have Oracle 8i installed on one
> > > computer and Oracle 8 on another and then I want to import the .dmp
> > > file exported from Oracle 8i.
> > > I hope this is clear to you now.
> > >
> > >
> > > TIA
> > >
> > >
> > > Hassan
> >
> > I hope my answer was clear enough and you did understood it. Seems
> > like you suggest I cannot read.
> > If the two systems can not be connected you are simply STUCK.
> > YOU CANNOT IMPORT A 8I EXPORT INTO 8. PERIOD!!!
> >
> > Regards
> >
> > Sybrand Bakker
> > Senior Oracle DBA
>
> hi Sybrand Bakker
>
> then what is the use of running catexp7.sql,I thank u once again

You need to run catexp7.sql in the Oracle 8(i) database to allow exp from Oracle 7 to run against the Oracle 8)i) database. You CANNOT run imp from 7.3 on a 8i export. You also NOT use imp from 8.0 to imp a 8i export, which is what he wants to accomplish. This is a documented 'feature', if he doesn't want to believe me, he should just RTFM

Regards

Sybrand Bakker
Senior Oracle DBA Received on Wed Jan 23 2002 - 11:15:35 CET