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';

原文地址:https://www.cnblogs.com/oracle-ziyuhou/p/14138893.html