1. The ALTER TABLE...MOVE
statement enables you to relocate data of a non-partitioned table or of a partition of a partitioned table into a new segment, and optionally into a different tablespace for which you have quota.
(ALTER TABLE...MOVE可以对非分区表重新设置数据的存放位置、可以对分区表的一个分区移动到新的段中,甚至你能够转移到不同的表空间中。)
2. This statement also lets you modify any of the storage attributes of the table or partition, including those which cannot be modified using ALTER TABLE
. You can also use the ALTER TABLE...MOVE
statement with the COMPRESS
keyword to store the new segment using table compression.
The following statement moves the
hr.admin_emp
table to a new segment, specifying new storage parameters:
(该语句能够修改非分区、分区表的存储属性,而alter table 语句却不能设置。用ALTER TABLE...MOVE 移动表到新的段中可以用comp