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. 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.
ALTER TABLE ...MOVE语句允许你去重新定位一个非分区表或者分区表的一个分区到一个新的段,
并且可以选择在不同的你拥有分配额的表空间。这个语句也可以让你去修改表或者分区的任何存储
属性,包含包含那些不能通过ALTER TABLE 修改的。你也可以使用ALTER TABLE...MOVE语句用
COMPRESS关键词去存储到新的段使用表的压缩属性。
Note: The ALTER TABLE...MOVE statement does not permit DML
against the table while the statement is executing. If you want to leave
the table available for DML while moving it, see "Redefining Tables
Online" on page 15-21.
备注:ALTER TABLE ...MOVE语句不允许使用DML对于表相关语句正在执行。如果你想表对于DML是可用的
你可以参见“REDEFINING TABLES ONLINE"在15-21页
The following statement moves the hr.admin_emp table to a new segment,
specifying new storage parameters:
ALTER TABLE hr.admin_emp MOVE
STORAGE ( INITIAL 20K
NEXT 40K
MINEXTENTS 2
MAXEXTENTS 20
PCTINCREASE 0 );
-----------------------------------------------
Moving a table changes the rowids of the rows in the table. This causes indexes on the
table to be marked UNUSABLE, and DML accessing the table using these indexes will
receive an ORA-01502 error. The indexes on the table must be dropped or rebuilt.
Likewise, any statistics for the table become invalid and new statistics should be
collected after moving the table.
MOVE表会更改表行的ROWID,这将导致在表上的索引被标记为UNUSABLE,并且DML访问这个
表用这些索引时将会收到一个ORA-01502的错误。这个在表上的索引必须被DROP或者是重建的。
另外,任何表的统计信息将会变得不可用的而新的统计信息应该在MOVE完后去收集统计;
If the table includes LOB column(s), this statement can be used to move the table along
with LOB data and LOB index segments (associated with this table) which the user
explicitly specifies. If not specified, the default is to not move the LOB data and LOB
index segments.
如果表包含LOB列,这个段可以用于去移动表和LOB和LOB索引段(关联这个表的)用户要显式去
指定。如果不指定,默认是不移动LOB对象和LOB索引段。