Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Exporting an 8.1.6 db for a 7.3 db

Re: Exporting an 8.1.6 db for a 7.3 db

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: 2000/05/19
Message-ID: <8g38ln$34o$1@soap.pipex.net>#1/1

won't work. Your best bet is to dump to flat files and use sql-loader to load data. It doesn't make that much sense to me as to why it should work either given the different data types/data dictionary structure etc in 8 from 7

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Yurasis Dragon" <yurasis_dragonNOSPAM_at_yahoo.com> wrote in message
news:39208a92.40444886_at_news.rdc1.ab.home.com...

> 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 Fri May 19 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US