Re: Take an Oracle 8.1 export file back to an Oracle 7.1 database.

2003-08-14 Thread Tanel Poder
Title: Message Hi! You just set compatible and optimizer_features_enable to 8.1.7 ;) Tanel. - Original Message - From: Mladen Gogala To: Multiple recipients of list ORACLE-L Sent: Thursday, August 07, 2003 8:29 PM Subject: RE: Take an Oracle 8.1 export

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

2003-08-14 Thread DENNIS WILLIAMS
David - I haven't tried this going from Oracle 8 to Oracle 7, but the usual prescription is to export the data using an Oracle 7 exp binary. Can you install that on the source machine? Another approach would be to create a database link between the two systems and use the SQL*Plus COPY command to

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

2003-08-14 Thread Mercadante, Thomas F
Title: 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

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

2003-08-07 Thread Mladen Gogala
Title: Message I'm very interested in finding out how will you import LOB's, Java classes, function based indexes, IOTand ADT objects into V7 database, especially if it is V7.1 and not 7.3.4 or 7.3.5. Please, keep us posted. --Mladen GogalaOracle DBA -Original Message-From: