Re: Export from 9i and import to 8i

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 Tue Jan 14 2003 - 02:09:20 CST