--更改表空间名字
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/,如需转载,请注明出处,否则将追究法律责任。