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>;

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.