Re: Error IMP-00017 [message #37199] |
Thu, 24 January 2002 01:03 |
Hans de Ruiter
Messages: 2 Registered: January 2002
|
Junior Member |
|
|
Cracked my head at the same problem, and found out why and got the solution. (thought; lets share this info) The reason for this problem lies in de difference of the statistics between Oracle versions. These are exported/imported too with an export/import. (except with analyze=N) Earlier statistics (see below for example) have 1 column less. Look at the error and see: ",," and Oracle expects ",NULL,". Found this out with an export of a 8.0.6 database and and import into 8.1.7. (In detail: Imported a 8.0.6 DB into 8.1.7: fine, exported it from 8.1.7: fine, imported it again into 8.1.7.: error. Why this error did'nt show up at the first time? Mhmmm bug?) The solution is simple; Go to the exporting database (in my case 8.1.7.) delete the statistics, run the export and import it into the target database. You will find that this solves the problem. Tricky....
|
|
|