I met a problem when I migrate from MySQL to Oracle by using SQL Developer (version 3.1.07).
During migrate, SQL Developer creates a temporary user that is used for migration process.
(Oracle recommended that should delete this user after finish)
However, this user is pointed to USERS tablespace by default.
I can not found the setting/option to change this setting!
The result is, data is stored into USERS area instead of my expected area.
I am using MySQL 4.x and Oracle 11gR2.
Everyone, please tell me if you know this. Thanks.
SQL Developer allows you to create a file that contains all objects instead of creating these objects immediately (step 7/9 Target Database here choose OFFLINE). So get this file and adopt it to your needs.