alter table mydb.mytab alter partition mytab201301 drop partition mytab201301;
alter table mydb.mytab add partition mytab201301 start (date '2013-01-01') inclusive end (date '2013-02-01') exclusive;
truncate table mydb.mytab201301_bak;
select count(*) from mydb.mytab201301_bak;
insert into mydb.mytab201301_bak select * from mydb.mytab201301;
alter table mydb.mytab drop partition mytab201301;
alter table mydb.mytab add partition mytab201301 start (date '2013-01-01') inclusive end (date '2013-02-01') exclusive;
insert into mydb.mytab select * from mydb.mytab201301_bak;
select count(*) from mydb.mytab_1_prt_mytab201301;
select count(*) from mydb.mytab201301;
修改字段类型和长度:
alter table mydb.mytab_bk_2013 alter ctc_pax_dat_txt type character varying(850);
alter table mydb.mytab_bk_2013 alter resp_pax_dat_txt type character varying(850);