admin_move_table在线更改分区键

db2 "call sysproc.admin_move_table(
'RECV',
'TRANS_SERIAL_TABLE',
'',
'',
'',
'',
'',
'(CREATE_TIME) (PART PART1 STARTING (''2000-01-01'') ENDING (''2001-01-01'') EXCLUSIVE,
PART PART2 STARTING (''2001-01-01'') ENDING (''2002-01-01'') EXCLUSIVE)',
'',
'',
'MOVE'
)"






CREATE TABLE "RECV    "."TRANS_SERIAL_TABLE"  (
  "ID" INTEGER , 
  "START_TIME" TIMESTAMP , 
  "CREATE_TIME" TIMESTAMP )   
PARTITION BY RANGE("START_TIME") 
(PART "P1" STARTING('2000-01-01-00.00.00.000000') ENDING('2001-01-01-00.00.00.000000') EXCLUSIVE IN "ISSUE", 
PART "P2" STARTING('2001-01-01-00.00.00.000000') ENDING('2002-01-01-00.00.00.000000') EXCLUSIVE IN "ISSUE") 
ORGANIZE BY ROW; 


 
db2 drop table recv.trans_serial_table


 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26224914/viewspace-2157187/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26224914/viewspace-2157187/