10g Table to 7i Table???

[topgun]

sir's/madam's

is it possible to export 10g records to a 7i DB?

its seems that dmp file is not compatible anymore ...
are there procedures for this or its not possible?


thanks...

IMP-00010: not a valid export file, header failed verification
IMP-00021: operating system error - error code (dec 2, hex 0x2)

[topgun]

will SQLLDR works...??? 10g to 7i


thanks

[hacketta1]

Using the Oracle7 SQL*Loader binary will work. Since you will loading a plain ASCII text file there are no issues in terms of compatibility.

[TimHall]

Hi.

The documentation for 10g release 2 provides this matrix:

http://download-uk.oracle.com/docs/c...htm#sthref2852

It does not go as far back as Oracle 7, but the 8i executable would work with Oracle 7, which implies there could be an indirect route back, although I've never tried it.

Cheers

Tim...

[dbasan]

That's possible!

you need to have the oracle 7 exp executable to export the 10g data and imp using the oracle 7 executable. I did with Oracle 9i to 8 this way.

How abt using DBlink, if the data needed from few tables?

[hacketta1]

How abt using DBlink, if the data needed from few tables?

I was looking into client interoperability for someone recently. According to Metalink note 207303.1 10g has never been certified with 7.3.4 (earliest version on Matrix). Going from a 10g client to a 7.3.4 server, you can expect an ORA-3134 if you try it (assuming the note is to be believed). 9.0.1 to 7.3.4 was once a certified combination, but nothing higher than that was ever supported.

[topgun]

Thanks to all..... I will try to export
the data of 10g using the 7i exp function....

[topgun]

i inserted tnsnames.ora of the 10g in my unix 7i server
but it seems it does not work since i am trying to connect it first
via sqlplus to check if the exp module will connect to my 10g DB.
am i missing something?

ERROR: ORA-01034: ORACLE not available
ORA-07318: smsget: open error when opening sgadef.dbf file.
HP-UX Error: 2: No such file or directory

[topgun]

while trying the dblink from 7i to 10g...i have an error
ORA-03115

[TimHall]

Hi.

The problem here is that connections from a 10g client to a 7.3.4 server are not supported. A database link works by make a client connection from one server to the other, hence your problem. I don't think this is a sensible route forward.

Cheers

Tim...