Oracle settings default tablespace when tables are created

When you import/create an Oracle database table, sometimes we examine the discovery, import/create table, and the table space created is not the default table space we want. At this point we need to modify the user's default tablespace and then import the way to resolve the problem.

Alter user your user name default tablespace you want tablespace

For example: Alter USER platform default Tablespace platform

When the execution takes effect, the script is imported, or the table is created, in the specified default space.

Oracle settings default tablespace when tables are created