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

Oracle consulting has DUL (data unloader) that allows you to peek into datafiles and dump the contents to ascii.

Mucho expensive for those guys though

You have postings on how to create a readable dump file in 8i from 9i, shortcuts will only get you into trouble ;-)

steve

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:<ujais9jrs87d5_at_corp.supernews.com>...
> "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
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
>
> completely correct. Any higher version export is 100 percent useless on a
> lower version database, as is *well* documented.
>
> Regards
Received on Wed Jul 17 2002 - 14:02:17 CDT