<div>
alter table your_existing_table_name move tablespace new_tablespace_name;
</div>


alter table your_existing_table_name move tablespace new_tablespace_name;

<div>
Also ensure that the user's default tablespace is changed to the new tablespace. Else, all new objects created in future might end up in the wrong TS again.<br />
<br />
alter user &lt;username&gt; default tablespace &lt;new_table_space&gt;;
</div>


Also ensure that the user's default tablespace is changed to the new tablespace. Else, all new objects created in future might end up in the wrong TS again.

alter user <username> default tablespace <new_table_space>;

<div>
thanks.<br />
the situation is more complicated than that.<br />
The old_table_space is SHARED by multiple schema. I only want to move one schema to another new_table_space. what should I do? thanks.<br />
<br />

</div>


thanks.
the situation is more complicated than that.
The old_table_space is SHARED by multiple schema. I only want to move one schema to another new_table_space. what should I do? thanks.



<div>
this question was answered.
</div>


<div>
<div class="content wysiwyg-content">
dear experts,<br />
<br />
i accidentally created a user with wrong tablespace. after he created some objects, I want to move everything he owned to another tablesapce. is ther a way to do this? thanks.
</div>
</div>


dear experts,

i accidentally created a user with wrong tablespace. after he created some objects, I want to move everything he owned to another tablesapce. is ther a way to do this? thanks.

how to move one schema objects to another tablespace?

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.