Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> using Oracle 7 export against an Oracle8 database
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.
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