当前位置: 代码迷 >> 综合 >> ALTER TABLE...MOVE 相关使用方法
  详细解决方案

ALTER TABLE...MOVE 相关使用方法

热度:47   发布时间:2023-12-22 07:52:57.0

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
  相关解决方案