Re: Importing Oracle 7.3.4 dmp file into 8i

From: Terry Steyaert <steyaert_at_my-deja.com>
Date: Mon, 16 Oct 2000 15:09:33 GMT
Message-ID: <8sf5n7$h08$1@nnrp1.deja.com>

This should be able to be done. (The one problem might be from a RISC box to an Intel box with the high-byte/low-byte swapping. I don't know if Oracle will take care of that.)

Personally, our old system ran Oracle 6.0.3.30, and those databases easily impoted into Oracle 8.0.5 and 8.1.5, but these were both from Intel based Unix systems. (Interactive for 6.0 and RedHat Linux for 8.x)

We have a script that we use to import databases. We call it imp_db and place it somewhere in your path. Then just type imp_db filename and it should handle importing the file.

Here's the script.

---

if [ $# -ne 1 ]
then

        echo "$0: Syntax: $0 FILENAME" else

        imp oracle/oracle1 FILE=$1 FULL=Y IGNORE=Y COMMIT=Y fi

---

Hope this helps.

Terry Steyaert
steyaert_at_my-deja.com
In article <8s0j66$911$1_at_nnrp1.deja.com>,   msis3157_at_my-deja.com wrote:
> Hi
>
> I'm a new/temporary user of Oracle 8i who needs to import a dmp file
 created
> in version 7.3.4 into 8i. I think I have set everything up right but
 when I
> do the import using the Wizard it boots me out with an authentication
 erro
> VNI-2015, I think the preffered credentials are correct and am
 importing as
> system sysdba.
>
> Any advice would be appreciated.
>
> Martin
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Oct 16 2000 - 10:09:33 CDT