From: pjm <pj...@sa...> - 2002-06-27 19:06:37
|
Not sure if I sent this earlier, apologies if I have.... the constraints given in the CVS files are listed in alabetical order which means I keep rerunning the file till it works - it tries to create foreign keys to not yet existing primary keys. For Oracle 8 you can dump; primary keys unique contraints foreign keys in that order. In Oracle 9 we think a fancy feature exists that works out the correct order for you or just does the above. |