Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> using Oracle 7 export against an Oracle8 database

using Oracle 7 export against an Oracle8 database

From: <junlei_at_my-deja.com>
Date: Tue, 26 Oct 1999 17:09:31 GMT
Message-ID: <7v4n87$a52$1@nnrp1.deja.com>


OS: Solaris 2.6

I needed to export a table from a 8.0.5 database and import it into a 7.3.4 database.

Here's what I did.

  1. run the catexp7.sql as sys in the 8.0.5 database.
  2. /../oracle/product/7.3.4/bin/exp username/password parfile=xxxx

It generated a core dump.

After talking with Oracle support, I was told to do the following:

1 - Under v8 database run CATEXP7.SQL connected as SYS or INTERNAL. 2 - Export while pointing to the V7 executable and the V8 database,

    using the SQLNET address of the v8 db.

        UNIX example:

% setenv ORACLE_HOME <V7 ORACLE_HOME directory>
% setenv ORACLE_SID V7SID
% exp scott/tiger_at_T:machine_name:V8SID

3 - Import the V7 export file using normal import procedures.

Frankly, this doesn't make sense to me, especially the V7SID part. But never mind that. I tried it, it again generated a core dump. Called Oracle again two days ago. Still waiting.

Does anyone have a suggestion or a solution?

Thanks.

Junlei

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 26 1999 - 12:09:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US