Are constraints disabled when loading the data?
Yes. By default, the Migration Wizard first creates the users and their tables, then loads the data, and finally creates all constraints. This avoids problems. It is possible to migrate the database to an Oracle database in stages. For example, you can first create the users and their tables, then create the constraints, and finally load the data. However, doing this might cause problems as a result of referential integrity. Therefore, Oracle Corporation recommends the default implementation.