Re: Export 8.1.7 - Import 7.3.4

Ron,

  Something I forgot and which Dennis' remark about format reminded me of :
You'll probably have to run $ORACLE_HOME/rdbms/admin/catexp7.sql againts your 8.1.7 database before you can use the Oracle7 exp against it (and run catexp again once you're done). File formats should be OK if your .dmp is generated by the same version for exp and imp, but the internal tables used by the utility have changed.

DENNIS WILLIAMS wrote:
>
> Ron
> You could try getting the 7.3.4 export to run against the 8.1.7 database.
> I don't know if the 32 vs 64 bit would affect you. Also, datafile formats
> changed between Oracle 7 and 8 and I haven't tried this particular export.
> Maybe somebody on the list has.
>
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
> -----Original Message-----
> Sent: Friday, August 15, 2003 4:54 PM
> To: Multiple recipients of list ORACLE-L
>
> I need to export the data from an Oracle 8.1.7 database HPUX 64 and
> import it back into an old 7.3.4 HPUX 32 database.
> The 7.3.4 import doesn't like the 8.1.7 export file.
>
> Any ideas?
>
> Ron Smith

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).