Oninit cdi / Archive
Talk to an expert →

dbexport miracle

Posted in 1999

Topics: Migration, Import/Export & Data Conversion

mhiller@my-dejanews.com — — source: Informix-list mailing list archive (1991-1998)

Hi, i 'dbexport'ed a database and dropped it. When i try to 'dbimport' i get err 239: "Could not insert new row - duplicate Value in a unique index column". The particular table only contains a unique indexed int field and a text field. I checked the unload file and actually there were double columns! How can this be? (Online 5.02, SCO 3.2v5.0.2) -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

↪ replying to mhiller@my-dejanews.com
Klaus Mueller — — source: Informix-list mailing list archive (1991-1998)

mhiller@my-dejanews.com wrote: > Hi, > i 'dbexport'ed a database and dropped it. > When i try to 'dbimport' i get err 239: > "Could not insert new row - duplicate Value in > a unique index column". > The particular table only contains a unique indexed int field > and a text field. > I checked the unload file and actually there > were double columns! > > How can this be? > > (Online 5.02, SCO 3.2v5.0.2) > > -----------== Posted via Deja News, The Discussion Network ==---------- > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Hi; dbexport will not do checks; it exports the data only (with unload: sequential read, therefore no access to the indexes). Before doing a dbexport of a certain database: check the database with the tbcheck-cmds (esp. tbcheck -cI ...).

Glossary