In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.