\u4e00\u76f4\u8ba4\u4e3a\uff0c\u8868\u88ab\u5220\u9664\u540e\uff0c\u666e\u901a\u7684\u89c6\u56fe\u4e2d\u662f\u67e5\u8be2\u4e0d\u5230\u8868\u4fe1\u606f\u7684\uff0c\u53ea\u6709\u4eceRECYCLBIN\u76f8\u5173\u89c6\u56fe\u624d\u80fd\u770b\u5230\u88ab\u5220\u9664\u7684\u8868\uff0c\u6ca1\u60f3\u5230\u6700\u8fd1\u53d1\u73b0\u5206\u533a\u8868\u7684\u76f8\u5173\u89c6\u56fe\u4e2d\u4ecd\u7136\u4fdd\u7559\u88ab\u5220\u9664\u8868\u7684\u4fe1\u606f\u3002
\n\u770b\u4e00\u4e2a\u7b80\u5355\u7684\u4f8b\u5b50\uff1a<\/p>\n
SQL> CREATE TABLE T_PART (ID NUMBER, NAME VARCHAR2(30))\r\n 2 PARTITION BY HASH (ID)\r\n 3 PARTITIONS 4;\r\n\u8868\u5df2\u521b\u5efa\u3002\r\nSQL> SELECT TABLE_NAME, PARTITIONING_TYPE, PARTITION_COUNT, STATUS\r\n 2 FROM USER_PART_TABLES;\r\nTABLE_NAME PARTITION PARTITION_COUNT STATUS\r\n------------------------------ --------- --------------- --------\r\nT_PART HASH 4 VALID\r\nSQL> SELECT TABLE_NAME, PARTITION_NAME, PARTITION_POSITION \r\n 2 FROM USER_TAB_PARTITIONS;\r\nTABLE_NAME PARTITION_NAME PARTITION_POSITION\r\n------------------------------ ------------------------------ ------------------\r\nT_PART SYS_P61 1\r\nT_PART SYS_P62 2\r\nT_PART SYS_P63 3\r\nT_PART SYS_P64 4\r\nSQL> SELECT TABLE_NAME, STATUS, DROPPED\r\n 2 FROM USER_TABLES\r\n 3 WHERE TABLE_NAME = 'T_PART';\r\nTABLE_NAME STATUS DRO\r\n------------------------------ -------- ---\r\nT_PART VALID NO<\/pre>\n\u5efa\u7acb\u4e00\u4e2a\u5206\u533a\u8868\uff0c\u53ef\u4ee5\u4ece\u5206\u533a\u76f8\u5173\u7684\u6570\u636e\u5b57\u5178\u4e2d\u67e5\u8be2\u5230\u8fd9\u4e2a\u5206\u533a\u8868\u7684\u4fe1\u606f\uff0c\u4e0b\u9762\u5220\u9664\u8fd9\u4e2a\u8868\uff1a<\/p>\n
SQL> DROP TABLE T_PART;\r\n\u8868\u5df2\u5220\u9664\u3002\r\nSQL> SELECT TABLE_NAME, PARTITIONING_TYPE, PARTITION_COUNT, STATUS\r\n 2 FROM USER_PART_TABLES;\r\nTABLE_NAME PARTITION PARTITION_COUNT STATUS\r\n------------------------------ --------- --------------- --------\r\nBIN$dtFNG1JsS26GLpXZhpv56A==$0 HASH 4 VALID\r\nSQL> SELECT TABLE_NAME, PARTITION_NAME, PARTITION_POSITION \r\n 2 FROM USER_TAB_PARTITIONS;\r\nTABLE_NAME PARTITION_NAME PARTITION_POSITION\r\n------------------------------ ------------------------------ ------------------\r\nBIN$dtFNG1JsS26GLpXZhpv56A==$0 SYS_P61 1\r\nBIN$dtFNG1JsS26GLpXZhpv56A==$0 SYS_P62 2\r\nBIN$dtFNG1JsS26GLpXZhpv56A==$0 SYS_P63 3\r\nBIN$dtFNG1JsS26GLpXZhpv56A==$0 SYS_P64 4\r\nSQL> SELECT TABLE_NAME, STATUS, DROPPED\r\n 2 FROM USER_TABLES\r\n 3 WHERE TABLE_NAME = 'T_PART';\r\n\u672a\u9009\u5b9a\u884c\r\nSQL> SELECT TABLE_NAME, STATUS, DROPPED\r\n 2 FROM USER_TABLES\r\nTABLE_NAME STATUS DRO\r\n------------------------------ -------- ---\r\nSERVICES VALID NO\r\nCOMPANIES VALID NO\r\nSERVICE_USERS VALID NO\r\nSERVICE_USAGE VALID NO\r\nSERVICE_RATES VALID NO\r\nT_DEFER VALID NO\r\nT VALID NO\r\nT_P VALID NO\r\nT_F VALID NO\r\nMLOG$_T_P VALID NO\r\nMLOG$_T_F VALID NO\r\nMV_T_ORACLE VALID NO\r\nT_LOAD_LOB VALID NO\r\n\u5df2\u9009\u62e913\u884c\u3002<\/pre>\n\u663e\u7136\u8868\u88ab\u5220\u9664\u540e\uff0c\u8bb0\u5f55\u4eceUSER_TABLES\u8868\u4e2d\u88ab\u8fc7\u6ee4\uff0c\u4f46\u662f\u5728USER_PART_TABLES\u548cUSER_TAB_PARTITIONS\u4e2d\u8bb0\u5f55\u4ecd\u7136\u5b58\u5728\u3002\u8fd9\u8bf4\u660eOracle\u7684\u89c6\u56fe\u7684\u4e00\u81f4\u6027\u5de5\u4f5c\u505a\u7684\u5e76\u4e0d\u597d\uff0c\u5bfc\u81f4\u89c6\u56fe\u4e2d\u5305\u542b\u7684\u8bb0\u5f55\u6027\u8d28\u4e0d\u7edf\u4e00\u3002
\n\u90a3\u4e48\u67e5\u8be2\u5206\u533a\u76f8\u5173\u89c6\u56fe\uff0c\u9700\u8981\u5173\u8054*_TABLES\u89c6\u56fe\uff0c\u624d\u80fd\u83b7\u53d6\u5230\u5f53\u524d\u6ca1\u6709\u88ab\u5220\u9664\u7684\u5206\u533a\u8868\u6216\u8868\u5206\u533a\u4fe1\u606f\u3002\u5f53\u7136\u5982\u679c\u5bf9\u4e8e\u4e25\u8c28\u6027\u8981\u6c42\u4e0d\u662f\u90a3\u4e48\u9ad8\u7684\u8bdd\uff0c\u901a\u8fc7\u8868\u540d\u8fdb\u884c\u8fc7\u6ee4\u4e5f\u662f\u4e00\u4e2a\u6bd4\u8f83\u51c6\u786e\u4e14\u7b80\u5355\u6613\u884c\u7684\u65b9\u6cd5\u3002
\n\u6700\u540e\u63d0\u4e00\u4e0b\uff0c*_TABLES\u89c6\u56fe\u4e2d\u7684DROPPED\u5217\u4f3c\u4e4e\u5e76\u6ca1\u6709\u4ec0\u4e48\u610f\u4e49\uff0c\u56e0\u4e3a\u88ab\u5220\u9664\u7684\u5bf9\u8c61\u5df2\u7ecf\u4ece\u89c6\u56fe\u4e2d\u88ab\u8fc7\u6ee4\uff0c\u6000\u7591Oracle\u5728\u8bbe\u8ba1\u5b57\u6bb5\u548c\u89c6\u56fe\u7684\u65f6\u5019\u5e76\u6ca1\u6709\u8003\u8651\u597d\uff0c\u4eceDBA_TABLES\u89c6\u56fe\u4e2d\u53ef\u4ee5\u53d1\u73b0\uff0c\u6240\u6709\u7684\u8bb0\u5f55\u8fd9\u4e2a\u503c\u90fd\u662fNO\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u4e00\u76f4\u8ba4\u4e3a\uff0c\u8868\u88ab\u5220\u9664\u540e\uff0c\u666e\u901a\u7684\u89c6\u56fe\u4e2d\u662f\u67e5\u8be2\u4e0d\u5230\u8868\u4fe1\u606f\u7684\uff0c\u53ea\u6709\u4eceRECYCLBIN\u76f8\u5173\u89c6\u56fe\u624d\u80fd\u770b\u5230\u88ab\u5220\u9664\u7684\u8868\uff0c\u6ca1\u60f3\u5230\u6700\u8fd1\u53d1\u73b0\u5206\u533a\u8868\u7684\u76f8\u5173\u89c6\u56fe\u4e2d\u4ecd\u7136\u4fdd\u7559\u88ab\u5220\u9664\u8868\u7684\u4fe1\u606f\u3002 \u770b\u4e00\u4e2a\u7b80\u5355\u7684\u4f8b\u5b50\uff1a SQL> CREATE TABLE T_PART (ID NUMBER, NAME VARCHAR2(30)) 2 PARTITION BY HASH (ID) 3 PARTITIONS 4; \u8868\u5df2\u521b\u5efa\u3002 SQL> SELECT TABLE_NAME, PARTITIONING_TYPE, PARTITION_COUNT, STATUS 2 FROM USER_PART_TABLES; TABLE_NAME PARTITION PARTITION_COUNT STATUS —————————— ——— ————— ——– T_PART HASH 4 VALID … Continue reading