Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to modify the table space in the database, which has a certain reference value. Interested friends can refer to it. I hope you will gain a lot after reading this article.

After you modify the tablespace, you need to rebuild the index

1. Query tablespace

Select table_name,tablespace_name from user_tables where tablespace_name=' table space name'

2. Modify the tablespace

Alter table Table name move tablespace Tablespace

3. Query all indexes under the user

Select index_name,index_type,tablespace_name,table_type,status from user_indexes where tablespace_name=' table space name'

4. Re-establish the index

Alter index index name rebuild

Thank you for reading this article carefully. I hope the article "how to modify the tablespace in the database" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.