Posted 10 March 2005 - 10:44 AM
I am having problems whilst migrating data from Pro-isam to Oracle.
The error is very intermittant and very irritating.
I have created 11 Oracle tables from 11 .pro files and then created 11 functions to delete from the .pro files and add to the Oracle tables.
The functions are designed to run on to the next one, and this is where the problem is. If I run them singlely they are fine and the data migrates successfully, but if I tag them all together the 2nd function will always fall over, with the most common Oracle error message ; unique constraint.
I have inserted WAITS in between the functions but this doesn't resolve the issue either.
Any Ideas ?
Posted 10 March 2005 - 11:40 AM
Yes, the indexes on the Oracle tables match the key structure of the pro isam files.
All data that was written with CO/DIV = 'Y' has now been converted to have @COMP as the first key.
Posted 10 March 2005 - 03:39 PM
This is prob a dumb statement but If you're only keying the file on the value of @COMP then the unique constraint against the table is going to fall over every time. Like I said - prob dumb question.
Can you post a DB schema for the table it falls over on?
Reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users