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@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 - 03:31:58 CDT
