Hello! as i further try to examine why i'm not able to import the data i followed your suggestion to remove the foreign key of the table which the loader command dbload tells that theres the ref. int. violation. after removing the foreign key the data was imported successfully. at least the loader tells me so and also the log file. but: if i want to add the foreign key constraint again then the ref. int. violation comes up again. a check in the parent table shows that there are many records missing. and thats the reason for the ref. int. violation, because there are many records in the child table without a corresponing record in the parent table...
unfortunately, i cannot check if the missing records aren't exported because i'm only able to use pages or records format for the export, not formatted. after another try i get the following problem in the parent table after the import with the foreign key deactivated: i want to select the data of the parent table, but get the following error: General error;-2003 POS(8) Output columns too long select * from orders if i select individual columns then the statement succeeds, but no records are returned. (in the database where the data where exported everything works fine...) now i have no idea what to do next... ;-( Mit freundlichen Grüßen / Kind regards, Chris Jölly Unycom Information Technology Services GmbH Solutions for Intellectual Property Management Tel.: +43-316-818 818-30 > -----Ursprüngliche Nachricht----- > Von: Chris Jölly > Gesendet: Freitag, 13. April 2007 15:16 > An: Chris Jölly; 'David Krcek' > Cc: '[EMAIL PROTECTED]' > Betreff: AW: AW: Database migration from ASCII to UNICODE > > > Hi David, > > please forget my last info about the creation of the tables. > I didn't remember that the user dba isn't able to 'see' the tables. > > Logged in correct and all tables are there and coorect too... > > so there remains the problem with the referential integrity... > > > Mit freundlichen Grüßen / Kind regards, > Chris Jölly > Unycom Information Technology Services GmbH > Solutions for Intellectual Property Management > Tel.: +43-316-818 818-30 > > > > > > -----Ursprüngliche Nachricht----- > > Von: Chris Jölly [mailto:[EMAIL PROTECTED] > > Gesendet: Freitag, 13. April 2007 13:18 > > An: David Krcek > > Cc: [EMAIL PROTECTED] > > Betreff: AW: AW: Database migration from ASCII to UNICODE > > > > > > Hello David, > > > > thanks for your hint. unfortunately no tables are created if > > i import the > > catalog first. is it possible to deaktivate the ref int. > > checks during the import and reenable it afterwards? > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
