Re: Import from 8.1.6 to 8.1.5?

From: Gerrit-Jan Linker <gjlinker_at_oraxcel.com>
Date: Sun, 8 Jul 2001 17:18:28 +0100
Message-ID: <9ia10o$4cq$1@uranium.btinternet.com>

Hi,

To shuttle some data between your database you could also use SQL*XL. SQL*XL can fetch the data into Excel. You can connect to your target database next and bulk upload (a one click procedure almost) the data into the other database.

SQL*XL can be found at www.oraxcel.com

Hope this helps,

--
Gerrit-Jan Linker
SQL*XL: addin for Excel for easy access to Oracle databases
http://www.oraxcel.com


"farul ghazali" <goober1_at_cuberoot.net> wrote in message
news:goober1-246A4B.09465705072001_at_news.bellatlantic.net...


>

> I have a production machine on an Alphaserver running Compaq Tru64 unix.

> I'm trying to export the whole database and import it on a Solaris Sparc

> box for testing. The Alpha is running Oracle 8.1.6, the Solaris box is

> running Oracle 8.1.5. After doing an exp full=yes on the Alpha, the

> Solaris machine didn't like the file. Error message was

>

> Connected to: Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production

> With the Partitioning and Java options

> PL/SQL Release 8.1.5.0.0 - Production

>

> IMP-00010: not a valid export file, header failed verification

> IMP-00000: Import terminated unsuccessfully

>

>

> Question is, is it possible to do imp on an 8.1.5 from an export made

> from an Oracle 8.1.6 system? Or is this an issue with transferring

> between different OSes?

>

> TIA

Received on Sun Jul 08 2001 - 11:18:28 CDT