Re: [Q] export from ORACLE 8i into ORACLE 7 problem ?

From: <Winnie_Liu_at_infonet.com>
Date: Fri, 26 May 2000 09:23:41 -0700
Message-Id: <10509.106893@fatcity.com>

YOu will need to use the 734 export utility to run against your oracle 8i database. It will generate a 7 readable import file. Then you will have to use the 734 import utility to read it back in.

$ORACLE_734_HOME/bin/exp <username>/<password>@816DB <other options>

Winnie

L <leed_at_chele.cais.net> on 05/26/2000 08:20:18 AM

To: oracle-l_at_fatcity.com, oracledba_at_quickdoc.co.uk cc: (bcc: Winnie Liu/HQ/ISC)

Subject: [Q] export from ORACLE 8i into ORACLE 7 problem ?

We have ORACLE 8i (8.1.6.1.0) on SUN SOlaris 7. on 8i I first run catexp7.sql then export full database and "ftp" transfer to another SUN SOlaris computer. This computer has ORACLE 7.3.4.5 installed. i tried to import the database and have following error come ot:

Import: Release 7.3.4.5.0 - Production on Fri May 26 11:19:49 2000

Password:

Connected to: Oracle7 Server Release 7.3.4.5.0 - Production With the distributed and parallel query options PL/SQL Release 2.3.4.5.0 - Production

IMP-00010: not a valid export file, header failed verification
IMP-00021: operating system error - error code (dec 2, hex 0x2)
IMP-00000: Import terminated unsuccessfully

I called ORACLE support and they insist the problem is O.S. problem (ftp transfer NOT use "bin" mode). I have been tried this several times and also use different computers they all the same. Does anyone know why?

Thanks.

If you're bored, then visit the list's website: http://www.lazydba.com (updated daily)
to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk Received on Fri May 26 2000 - 11:23:41 CDT