How Oracle tables move tablespaces

In this issue, the editor will bring you about how the Oracle table moves the tablespace. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article.

In oracle, you sometimes need to move tables to other tablespaces. Here are the steps to move them.

First, use the following command to move:

Alter table table_name move tablespace tablespace_name

Then, if there is an index, you must rebuild the index:

Alter index index_name rebuild tablespace tablespace_name

The points to be noted are:

1. If you need to move the data of lob-related fields in the table at the same time, you must use the following statement containing special parameter data.

Alter table tb_name move tablespace tbs_name lob (col_lob1,col_lob2) store as (tablesapce tbs_name)

If you have a large number of tables, you can produce an executed script.

Select 'alter index' | | OWNER | |'. | | index_NAME | | 'rebuild tablespace tablespace_name;' from dba_indexes where OWNER='USERS'

Select 'alter table' | | OWNER | |'. | | TABLE_NAME | | 'move tablespace tablespace_name;' from dba_tables where OWNER='USERS'

This is how the Oracle table shared by the editor moves the tablespace. If you happen to have similar doubts, please refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.