oracle partition table related operations(二)
te Range or List method
从上面可以看出，HASH分区表的分区时不可以被DROP的。但是是可以进行MOVE的。
move hash patition:
SQL> alter table hashtest move partition SYS_P49 tablespace users;
Table altered.
SQL> select table_NAME,PARTITION_NAME from user_tab_partitions where table_name='HASHTEST';
TABLE_NAME PARTITION_NAME
------------------------------ ------------------------------
HASHTEST SYS_P49
HASHTEST SYS_P50
HASHTEST SYS_P51
HASHTEST SYS_P52
HASHTEST SYS_P53
HASHTEST SYS_P54
HASHTEST SYS_P55
7 rows selected.
ADD hash partition
SQL> alter table hashtest add partition SYS_P56;
Table altered.
不能split partition
SQL> alter table hashtest split partition SYS_P49 at (1000);
alter table hashtest split partition SYS_P49 at (1000)
*
ERROR at line 1:
ORA-14255: table is not partitioned by Range, Composite Range or List method
Truncate hash分区
SQL> alter table hashtest truncate partition SYS_P49;
Table truncated.
Rename hash partition:
SQL> alter table hashtest rename partition SYS_P56 to SYS_P48;
Table altered.