oracle分区添加

查看分区 SQL> select partition_name, High_value from user_tab_partitions where table_name=‘XXXX’; 查看分区基于那个字段 select * from USER_PART_KEY_COLUMNS ； 添加表分区 alter table xxxx add partition P200901 values less than (TO_DATE(' 2009-01-31 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) tablespace xxxx;