Re: Export from 9i and import to 8i

Yep, and it might be necessary to install the '8i export views' on the 9i. They are named like : CATEXP....sql

regards
Stephan van Hoof

"Peter van Rijn" <p.vanrijnREMOVE_at_THISzhew.nl> wrote in message news:v27hg33h2kcmc7_at_corp.supernews.com...
> Sasa,
>
> Although Daniel is right in his grief about multi-/crossposting I think
he's
> being a bit harsh on you.
> If you check the Oracle 9i Utilities Guide on tahiti you'll find in
chapter
> 1 (export) details about exporting from a higher version to a lower
version
> database. Basically you need to use the lower version exp-utility to
create
> the export file. Otherwise "exp" wil export all kind of new stuff that
won't
> be understood by the 8i database and/or imp-utility.
>
> regards,
> Peter
>
>
> "DA Morgan" <damorgan_at_exesolutions.com> schreef in bericht
> news:3E22F8ED.3C27B52B_at_exesolutions.com...
> > Sasa Golub wrote:
> >
> > > Hi,
> > >
> > > I want to export database from Oracle 9i and import it on Oracle 8i,
but
> > > there is no compatibility from 9i to 8i. So, if anyone knows how can I
> do it
> > > (without manual "create table -- as select * from -- @--") I would be
> very
> > > greatfull.
> > >
> > > Thanks,
> > >
> > > Sasa.
> >
> > Did you have to cross-post your message to every usenet group you could
> spell?
> > In the future, please don't. One is enough.
> >
> > Had you not posted this everywhere I'd give you the solution. But as I
am
> tired
> > of seeing all of this multiposting I will refer you to
> http://tahiti.oracle.com
> > where the information you request is easily available.
> >
> > Daniel Morgan
> >
>
>
Received on Wed Jan 15 2003 - 13:39:23 CST