Multiple table spaces for Oracle Users

First, authorize the specified user.

There can only be one user's default tablespace, but you can try to use the following statement to authorize it to create a pair of images in another tablespace:

Alter user username Quota 0| | Unlimited on Tablespace_name;

Moreover, the order to create the table.

A user can have more than one table space when the table is created:

CREATE TABLE table_name () Tablespace tablespace_name so that the tables you created are under the specified space.

Finally, as for the query, insert and so on these you are understand ...

Multiple table spaces for Oracle Users