Thanks, will try to do that.
"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
Received on Tue Jun 18 2002 - 03:23:59 CDT
