This discussion is archived
1 Reply Latest reply: Sep 18, 2012 2:23 AM by kgronau RSS

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

962693 Newbie
Currently Being Moderated
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.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points