Importing in 8.1.6 dump of 9.2

[hsbdba]

Hi,

We have to servers ,

One for our financial which have 8.1.6 database server

the 2nd is for sales system have 9.2.0.1 database server

Currently i have to make interface so i have to export tables from the sales one and import it in the financial one.


i did the export from sales but it give me error when i try to export it in the 8.1.6 one ,

shal i have to execute the catexp of 8.1.6 in the 9.2 server and do the export again or there is a better solution


Regards

[sumit]

You took export from 9i DB and tried to export the same sump into 8.1.6.

Try the following

1. Take export from 9i(sales) DB using 9i EXP utility.
2. From the same server (Sales 9i) import data into 8.1.6 using same 9i IMP utility.

[stecal]

That is not correct. To go from 9i to 8i, use export of the 8i against the 9i database, and use import from 8i to import into the 8i database.

If you wanted to go from 8i to 9i, you would use 8i export to create the dump file from the 8i database, and then use the 9i import to import into the 9i database.


http://download-west.oracle.com/docs...mp.htm#1005557

[SANJAY_G]

Could you post complete error message?

[hsbdba]

Hi,

the error
is IMP-00010 Not valid export file , header failed verification

,

Regards

[hsbdba]

Thanks stecal

But can you tell me after i run the catexp.sql of 8i in the 9i server
what command should i use,
this is because after i execute the catexp.sql (8i) in the server of 9i, i exporting end with error of 904 ,

Regards,

[hsbdba]

Looking for seniors update,

Any one face such a problem ,


until now i cannot import from 9.2 and export it into 8.1.6


Hope you to hands on this issue

[vishal sood]

1. Take export of 9i database using 8i export utility and
do import in 8i database using 8i import utility.

2.

is IMP-00010 Not valid export file , header failed verification

The error may be because if u have tranferred the dump file thru FTP then it should not be in binary mode it should be in ANSI.

Thanks

[davey23uk]

ummm a dump file is a binary file

[vishal sood]

Dump file is not a Binery file, I mean to say is at the time of transferring file thru FTP, FTP may treat the file as Binary or ANSI.

In case the dump file considered as binery then at the time of importing it may give the IMP-010 error.

Thanks