Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Exporting an 8.1.6 db for a 7.3 db
No way using exp/imp. You have to hold your 7.3 exp/imp tools or you have to
write sql scripts, that load your data in ascii files. Then you have to create
loader scripts
and use the sqlloader to get these ascii data in the 7.3.4 databases. Somewhat
more complicated
but better to maintain and independent of versions.
Andy
Yurasis Dragon schrieb:
> Nope, catexp7.sql run against 8i allows exp (7.3.4) to export from an
> Oracle 8i db.
>
> I need to be able to export from an 8i db so that the resulting
> export can be imported into an 7.3.4 db. If I use the 7.3.4
> against an 8i db, no problem, the export can be sent to our
> clients and imported into their 7.3.4 db.
>
> But we'll be getting rid of 7.3.4 and I need a solution without 7.3.4.
>
> On Mon, 15 May 2000 23:03:15 +0100, "nntp.freeserve.co.uk"
> <Robert_at_gales.org.uk> wrote:
>
> >(Your question sounds the wrong way round..., but assuming it is right:)
> >Provided you run a special script (its in bin/scripts IIRC) against the 8.x
> >database first, you can then use EXP73 against it - v.vs. works anyway.
> >
> >Robert
> >
> >Yurasis Dragon <yurasis_spamNOSPAM_at_yahoo.com> wrote in message
> >news:fns0iso9uudob4d2omuks2e6ne78309q85_at_4ax.com...
> >> Since we're going to get rid of Oracle 7.3.4 and move entirely to
> >> 8.1.6, I'm trying to figure how we can get an export from an 8i
> >> database to a client with an 7.3.x db.
> >>
> >> I guess we can use a 7.3.4 export from a PC. I have tried moving
> >> exp from 7.3.4 to the 8i db server and running it from there - core
> >> dump.
> >>
> >>
> >> Any ideas?
> >>
> >>
> >>
> >
>
> ===
>
> Yurasis Dragon
> yurasis_dragonNOSPAM_at_yahoo.com
> (remove NOSPAM to reply)
Received on Tue May 16 2000 - 00:00:00 CDT