Forum Stats

  • 3,838,660 Users
  • 2,262,390 Discussions
  • 7,900,728 Comments

Discussions

Modify the default tablespace in Oracle 12cR2

I am working on Oracle 12c R2, I am doing migrations from SQL Server 2014 to this one, I do it with the migration assistant of SQL Developer, I want to know if there is any way that the default TABLESPACE that is placed when creating the scheme, because it always goes to USERS and I want them to get to a different one, so far my solution has been post-migration to move the tablespace objects, but this takes time, another thing I want to know is whether to You also, when placing a different length for the FLOAT data type, I use a FLOAT (49) but even though I specify this length to the assistant in the same way it does it with the default length of 126, I hope you can help