Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: URGENT: Importing an Oracle 9i export file into Oracle 8.1.7

Re: URGENT: Importing an Oracle 9i export file into Oracle 8.1.7

From: Telemachus <telemachus_at_ulysseswillreturn.net>
Date: Wed, 17 Jul 2002 13:23:31 +0100
Message-ID: <8ldZ8.2766$zX3.2317@news.indigo.ie>


No.
none at all.

connect the 817 database via SQLNET to the 9 and exp what you need - then import it into 8. There is NO other way to do it well there is - ctas x dblink ,replication,

Can't resist : upgrade the 817 to 9 and then it'll work.... but that's cruel.

"Sridhar" <sridhar_at_inapp.com> wrote in message news:ah3e3d$c53$1_at_news.vsnl.net.in...
> Hai All.
>
> Is there some API or tool somewhere which can read the export file and
> convert it into ASCII SQL files....
>
> Sridhar
>
>
> "nettdata" <nettdata_at_noSpAM_nettdata.com> wrote in message
> news:3D35372F.5000409_at_noSpAM_nettdata.com...
> > I could be wrong, but I think that you have to do an export from the 9i
> > database using the 8.1.7 export tool, and then import it into 8.1.7
> > using the 8.1.7 import tool.
> >
> > I don't believe that 8.1.7 import tool can process the 9i export file,
> > and I don't believe that 9i import will work on an 8.1.7 database.
> >
> > I would say that you have to install 9i somewhere and do an import into
> > it, and then do an export with 8.1.7's export before it will work.
> >
> >
> > $0.02
> >
> >
> > ...jeff
> >
> >
> > Sridhar wrote:
> > > Hai All
> > > I have got an Oracle 9i Export Script, though i dont have an oracle 9i
> > > installation.
> > > I want to import that file into an Oracle 8.1.7 installation.
> > > Please do Help me in this matter
> > > This is ugent
> > >
> > > Sridhar
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
>
>
Received on Wed Jul 17 2002 - 07:23:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US