Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to export 9i data and import it to 8i?
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 Tue Jun 18 2002 - 02:11:26 CDT