Move tables, table partitions, LOB fields, indexes, partition indexes to another table space!
Source: Internet
Author: User
move table, table partition, LOB field, index, partition index to another table space ALTER TABLE command move table, partition, LOB field
Alter INDEX command to move index, partition index
move table π move table (non-partitioned table): ALTER TABLE <schema.table> move tablespace <new tablespace>;
Move partitioned tables, which move each partition individually: ALTER TABLE <schema.table> move partition <partition> tablespace <new tablespace>;
Move LOB field, LOB field does not automatically move with table, must show move: ALTER TABLE <schema.table> move lob (<lob1, LOB2, ...>) store as (Tablespace < ; new tablespace>);
or move the table together:
ALTER TABLE <schema.table> move tablespace <new tablespace> lob (<LOB1, LOB2, ...>) store as (Tablespac e <new tablespace>);
Move index π move normal index, online option optional: Alter index <schema.idx> rebuild [online] tablespace <new tablespace>;
Move Partition index: ALTER INDEX <schema.idx> REBUILD partition < partition index > [online] tablespace <new tablespace>;
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.