Home » SQL & PL/SQL » SQL & PL/SQL » Re: Error IMP-00017
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....
Previous Topic: returning count of records fetched ref cursor
Next Topic: Error - ORA-21845 - HELP
Goto Forum:

Current Time: Mon Aug 02 11:16:42 CDT 2021