Re: How to export 9i data and import it to 8i?

Could you specify what were the bugs in 8i exp and the 8i client incompatibilities with 9i servers ?

Hemant

"Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> wrote in message news:aepfho$i17$1_at_babylon.agtel.net...
> Be aware that there were some bugs in 8i exp and some incompatibilities
> when 8i client talks to 9i database, so you better patch both 8i and 9i to
> latest patchsets available or you may end up with corrupt export or
> crashes.
>
> --
> Vladimir Zakharychev (bob_at_dpsp-yes.com)
http://www.dpsp-yes.com
> Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet
applications.
> All opinions are mine and do not necessarily go in line with those of my
employer.
>
>
> "Howard J. Rogers" <dba_at_hjrdba.com> wrote in message
news:aempe4$6g7$1_at_lust.ihug.co.nz...
> > Yup. Install the Oracle Client (8i version) and you should end up with
an
> > ORACLE_HOME\bin directory, in which the 8i version of export can be
found.
> >
> > Run export from there (or arranmge suitable PATH environment variables),
and
> > just connect as normal to the 9i Instance on your server (eg,
> > C:\oracle\bin\exp system/manager_at_db901 full=y rows=y
> > file=d:\exports\expdat.dmp)
> >
> > Regards
> > HJR
> >
> >
> > "Hartono Nugroho" <hanugro_at_hotmail.com> wrote in message
> > news:3d0edd2b$1_2_at_news5.nntpserver.com...
> > > Thanks, I am aware that I have to use same or lower version to exp
because
> > > it is in the manual. But I do not know where to get the lower version
of
> > > export to do the job.
> > >
> > > I try to copy only the exp 8i executable file but it does not work
because
> > > it seems that it needs few other dll files.
> > >
> > > My question would be how to actually do this job as easy as possible
> > because
> > > I could not find that info in the manual.
> > >
> > > Do I need to install Oracle client (lower/same version, eg 8i) on one
of
> > my
> > > workstation and run exp against 9i server from the workstation? Or is
> > there
> > > any other methods because basically I do not want to install full
Oracle
> > > client.
> > >
> > > Thanks in advance for your help.
> > >
> > >
> > > "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> > > news:8hktgukp1t7cjca61b7oi6h7cnl3ip1onh_at_4ax.com...
> > > > On Tue, 18 Jun 2002 11:40:03 +0700, "Hartono Nugroho"
> > > > <hanugro_at_hotmail.com> wrote:
> > > >
> > > > >Hi all,
> > > > >
> > > > >I need to export data from Oracle 9i database and import it into
Oracle
> > > 8i?
> > > > >Could you please help me on how to do this? Can I install 8i
client in
> > > one
> > > > >of the workstation and export from there?
> > > > >Any detailed explanation on how to achieve this would be
appreciated.
> > > > >Thanks in advance for your help.
> > > > >
> > > > >Regards,
> > > > >Hartono
> > > > >
> > > >
> > > >
> > > > You need to use the 8i exp against the 9i database.
> > > > It is always *lower version exp* against *higher version database*,
as
> > > > has been posted *numerous times*
> > > >
> > > > Regards
> > > >
> > > >
> > > > Sybrand Bakker, Senior Oracle DBA
> > > >
> > > > To reply remove -verwijderdit from my e-mail address
> > >
> > >
> >
> >
>
Received on Wed Jun 19 2002 - 08:17:12 CDT