Re: export from oracle8i and import into oracle8.0.5

have you spotted this conversation it should be adjusted for your versions and use the appropriate CATEXP*.sql scripts

Regards

Kevin

Hi

I migth have, I don't remember the versions of oracle, but anyway:

1. Start "svrmgr" at the Oracle8 database
2. Do a "Connect internal"
3. Run the script "catexp7.sql" (localed in rdbms80/admin)
4. Do an export with "exp" from Oracle7 towards Oracle8
5. Run the script "catexp.sql" in svrmgr in Oracle8 to reverse the catexp7.sql
6. Import as normal in Oracle7

Hope this helps!

xenologics wrote:
>
> Hey folks,
>
> I like to export data from a Linux 8.x Oracle Database and to import the
> data into a 7.3.3.6 HP-UX Oracle Database.
>
> Anybody an idea how to do so ?
>
> Thanks in advance
> Michael
>
> MailTo: mw_at_ley.de

--
Venlig hilsen
Frederik

--
Kevin A Lewis (BOCM PAULS LTD - Animal Feed Manufacturer - Ipswich England)

                        <KevinALewis_at_HotMail.com>

The views expressed herein by the author of this document are not necessarily those of BOCM PAULS Ltd. <michael_bialik_at_my-deja.com> wrote in message news:80f8pg$bil$1_at_nnrp1.deja.com...
> Hi.
>
> I tried an EXPORT from 8.0.4 and IMPORT to 7.3.2 - No Go.
> My Oracle support gave me an answer I posted in previous message.
>
> Michael.
>
> In article <80d22u$o68$1_at_nnrp1.deja.com>,
> sriviswa_at_hotmail.com wrote:
> > I had the same problem. Talked to Oracle and found that it is a
> > deficiency that they won't be fixing any soon. In fact, you can
> export
> > out of 8 and import into 7 but not from 8i to 8.0.5! So, don't sweat
> > it...it ain't gonna work.
> > In article <80comn$h39$1_at_nnrp1.deja.com>,
> > michael_bialik_at_my-deja.com wrote:
> > > Hi.
> > >
> > > As far as I know :
> > > Oracle supports EXPORT from old version amd IMPORT to new one.
> > > It does NOT supports the reverse direction.
> > >
> > > Michael.
> > >
> > > In article <3829BF1D.4A67EDA6_at_net-dept.de>,
> > > Thomas Jork <tj_at_net-dept.de> wrote:
> > > > hi there
> > > >
> > > > i have a problem with an import, which is exported from an oracle
> 8i
> > > > enterprise server.
> > > > i want to import into oracle8 standard server. if i start the
> import
> > > > with a command like :
> > > > imp formuser=bla touser=foo file=exp01.dmp
> > > > oracle throws the follwing exception:
> > > > imp-0008 unrecognized statement in the export file
> > > >
> > > > i have never had any problems with import/export, so i'm really
> > > > wondering about that.
> > > >
> > > > thanks in advance
> > > >
> > > > thomas
> > > >
> > > >
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> > >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Nov 16 1999 - 06:09:53 CST