I'm using Version 6.0.1.848 with Oracle 9iR2. I don't understand how it exported multi-lingual data using the "SQL inserts" option. I've got NLS_CHAR = AL32UFT8, and the generated INSERT statements for my Russian and Japanese and other non-Latin text appear to truncated my phrases to ASCII --...
I'm sorry, but this:
alter table TESTNOTNULL2 add constraint TESTNOTNULL2_COL5_NN check (COL5 IS NOT NULL);
is NOT the same as:
alter table TESTNOTNULL2 modify COL5 constraint TESTNOTNULL2_COL5_NN NOT NULL;
The former is a simple user-defined check constraint that happened to check for...