Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

How Oracle tables move tablespaces

2025-01-19 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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

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.

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report