1 Reply Latest reply: Sep 18, 2012 4:23 AM by Kgronau-Oracle RSS

    How to change the default tablespace when migrate by using SQL Developer

      Hi all,

      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.