How to move a table in oracle database?

Question

350 views16/07/2022Oracle Database

0

Amen1.09K 20/02/2022 0 Comments

What is purpose of moving a table and the SQL statement that enables us to move a table?

meda Changed status to publish 16/07/2022

Write your answer.

score 0 · Answer 1 · 2022-02-21T12:05:10+00:00

The purpose of moving a table is either to move to a new tablespace or rebuild its current tablespace.

We use the ALTER TABLE .. MOVE SQL statement for moving tables to a new tablespace.

Example:

SQL> ALTER TABLE sttms_cust_acc MOVE TABLESPACE <new-tablespace_name>;