RE: Take an Oracle 8.1 export file back to an Oracle 7.1 database

David,  

>From the machine where the 7.x database exists, run export and export the
data from the 8.x database. You will need to setup your tnsnames.ora file on the 7.x machine to get to the other box.  

Export the data you need, and import it into your 7.x database.  

No need to install the 7.x stuff on the other machine. Simply use Sql*Net to export the data across the nextwork.  

Good Luck!  

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Thursday, August 07, 2003 1:15 PM
To: Multiple recipients of list ORACLE-L

Hi all

Is it possible to take an Oracle Version 8.1 database export file and load it into an Oracle Version 7.1 database? The export file of the 8.1 is on a different machine than the 7.1 database. If I can not is there some other method I can use to get the data from the 8.1 export file to the 7.1 database.

Thanks
David

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mercadante, Thomas F
  INET: NDATFM_at_labor.state.ny.us

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).