12C 在线将非分区表改为分区表

 alter table TAB_STORED_LOG modify
      partition by range (STORED_DATE)
      interval (numtodsinterval(1,'day'))
  (
  partition part_20200101 values less than (to_date('20200101','yyyyMMdd'))
  ) online
      update indexes
  (
      STORED_BUSINESS_KEY GLOBAL
  );
 
 
select table_name,partition_name,high_value from user_tab_partitions where table_name='TAB_STORED_LOG';

posted @ 2020-12-15 15:20  子鱼猴  阅读(174)  评论(0编辑  收藏  举报