"Smith, Ron L." wrote: > > 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
I am unsure whether a 7.3.4 client can talk to a 8.1.7 database. It just *might*. I think I have a customer where there are database links between a 7.3 database who survives because of unmigratable Forms 3 applications and a prodction 8.1.7 database. In which case you should export across SQL*Net with the 7.3.4 exp. Otherwise try to regenerate what you can of the SQL from the .dmp file (with INDEXFILE= to get CREATE TABLE and CREATE INDEX statements, SHOW=Y and a lot of manual editing for the rest - unless you can find a perl tool to help), dump to flat files and use SQL*Loader. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
