创建了一个分区表,代码如下:
CREATE TABLE TEST_HASH2 (ID NUMBER)
PARTITION BY HASH(ID)
(PARTITION P2_1, PARTITION P2_2);
使用代码: drop table TEST_HASH2 删除该表后,select t.* from user_tab_partitions t 发现分区仍然存在,
如何删除分区?
CREATE TABLE TEST_HASH2 (ID NUMBER)
PARTITION BY HASH(ID)
(PARTITION P2_1, PARTITION P2_2);
使用代码: drop table TEST_HASH2 删除该表后,select t.* from user_tab_partitions t 发现分区仍然存在,
如何删除分区?
SQL> CREATE TABLE TEST_HASH2 (ID NUMBER)
2 PARTITION BY HASH(ID)
3 (PARTITION P2_1, PARTITION P2_2);
Table created
SQL> DROP TABLE TEST_HASH2;
Table dropped
SQL> select COUNT(*) from user_tab_partitions t ;
COUNT(*)
----------
2
SQL> purge recyclebin
2 ;
Done
SQL> select COUNT(*) from user_tab_partitions t ;
COUNT(*)
----------
0
SQL>
SQL > DROP TABLE TEST_HASH2 PURGE;