Failed Statement is: ALTER TABLE logicproperty ADD CONSTRAINT r_186 FOREIGN KEY ( zone_id ) REFERENCES zone ON DELETE CASCADE
You can include the foreign key constraints in the initial table definition itself, instead of creating the table and then adding the constraints to it later. Do you still get the OutOfMemory problem if you include all the foreign key constraints in the table definition itself, rather than as separate ALTER TABLE statements? Also, can you share the entire create_db.sql script? thanks, bryan