why don't you create a database link ,then 'insert into ...select .... @dblink?
Originally posted by nansbrain
I'm facing the following problem when trying to import from oracle 8.1.6 to 8.1.5
The error is as follows :
IMP-00010: not a valid export file, header failed verification
IMP-00021: operating system error - error code (dec 2, hex 0x2)
IMP-00000: Import terminated unsuccessfully
I've tried to export USER/TABLE etc., nothing works.
I've also tried to copy the exp/imp files across the versions and tried to use them...which results in an error in picking up the library.
I'm working on Solaris 2.7 on both the machines.
Pls. find if you can help.
Thanks in advance