mysql 修改分区名_修改数据库分区表分区名和所属表空间 限于Oracle10g

--更改表空间名字

alter tablespace S_GSM_PM_COVER_H_12 rename to S_GSM_PM_COVER_H_;

alter tablespace S_GSM_PM_NETSGROUP_H_12 rename to S_GSM_PM_NETSGROUP_H_;

alter tablespace S_GSM_PM_BSC_H_12 rename to S_GSM_PM_BSC_H_;

alter tablespace S_GSM_PM_BSC_H_11 rename to S_GSM_PM_BSC_H_;

alter tablespace S_GSM_PM_COUNTRY_H_12 rename to S_GSM_PM_COUNTRY_H_;

alter tablespace S_GSM_PM_COUNTRY_H_11 rename to S_GSM_PM_COUNTRY_H_;

--更改分区所属表空间

alter table GSM_PM_COVER_H move partition S_GSM_PM_COVER_H_ tablespace S_GSM_PM_COVER_H_;

alter table GSM_PM_NETSGROUP_H move partition S_GSM_PM_NETSGROUP_H_ tablespace S_GSM_PM_NETSGROUP_H_;

alter table GSM_PM_BSC_H move partition S_GSM_PM_BSC_H_ tablespace S_GSM_PM_BSC_H_;

alter table GSM_PM_BSC_H move partition S_GSM_PM_BSC_H_ tablespace S_GSM_PM_BSC_H_;

alter table GSM_PM_COUNTRY_H move partition S_GSM_PM_COUNTRY_H_ tablespace S_GSM_PM_COUNTRY_H_;

alter table GSM_PM_COUNTRY_H move partition S_GSM_PM_COUNTRY_H_ tablespace S_GSM_PM_COUNTRY_H_;

--更改表分区名字

alter table GSM_PM_COVER_H rename partition S_GSM_PM_COVER_H_ to PART_DTM_REPDATE_;

alter table GSM_PM_NETSGROUP_H rename partition S_GSM_PM_NETSGROUP_H_ to PART_DTM_REPDATE_;

alter table GSM_PM_BSC_H rename partition S_GSM_PM_BSC_H_ to PART_DTM_REPDATE_;

alter table GSM_PM_BSC_H rename partition S_GSM_PM_BSC_H_ to PART_DTM_REPDATE_;

alter table GSM_PM_COUNTRY_H rename partition S_GSM_PM_COUNTRY_H_ to PART_DTM_REPDATE_;

alter table GSM_PM_COUNTRY_H rename partition S_GSM_PM_COUNTRY_H_ to PART_DTM_REPDATE_;

来自 “ ITPUB博客 ” ，链接：/26940217/viewspace-732053/，如需转载，请注明出处，否则将追究法律责任。