能夠通過(guò)Flashback？

在Oracle數(shù)據(jù)庫(kù)中，單個(gè)刪除的分區(qū)并不會(huì)進(jìn)入回收站，全表刪除的分區(qū)才可能和全表一起放入回收站。這是因?yàn)閱蝹€(gè)分區(qū)刪除之后，是無(wú)法通過(guò)簡(jiǎn)單的閃回加入原分區(qū)表中，既然無(wú)法保證一致性，這個(gè)分區(qū)就不會(huì)進(jìn)入回收站中。

以下這個(gè)測(cè)試展示了這個(gè)過(guò)程：

SQL> select * from v$version;BANNER CON_ID-------------------------------------------------------------------------------- ----------Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production 0PL/SQL Release 12.2.0.1.0 - Production 0CORE 12.2.0.1.0 Production 0TNS for Linux: Version 12.2.0.1.0 - Production 0NLSRTL Version 12.2.0.1.0 - Production 0SQL> CREATE TABLE enmotech (2 PartID integer not null,3 CretTm date not null,4 PartCD varchar2(2) not null5 ) partition by list (partcd) automatic (6 partition pBJ values ('BJ'),7 partition pCD values ('CD'),8 partition pGZ values ('GZ'),9 partition pSH values ('SH')10 );Table created.SQL> insert into enmotech values (1, sysdate, 'KM');1 row created.SQL> select partition_name from user_tab_partitions2 where table_name = 'ENMOTECH';PARTITION_NAME--------------------------------------------------------------------PBJPCDPGZPSHSYS_P281SQL> alter table enmotech drop partition SYS_P281 purge;alter table enmotech drop partition SYS_P281 purge*ERROR at line 1:ORA-14048: a partition maintenance operation may not be combined with other operationsSQL> alter table enmotech drop partition PSH;Table altered.SQL> select * from user_recyclebin;no rows selectedSQL> drop table enmotech;Table dropped.SQL> select object_name,original_name,type from user_recyclebin;OBJECT_NAME ORIGINAL_NAME TYPE---------------------------------------- -------------------- -------------------------BIN$TflQLiTmWX7gUwo4qMBX+A==$0 ENMOTECH TABLEBIN$TflQLiTmWX7gUwo4qMBX+A==$0 ENMOTECH Table PartitionBIN$TflQLiTmWX7gUwo4qMBX+A==$0 ENMOTECH Table PartitionBIN$TflQLiTmWX7gUwo4qMBX+A==$0 ENMOTECH Table PartitionBIN$TflQLiTmWX7gUwo4qMBX+A==$0 ENMOTECH Table Partition

很多時(shí)候，想當(dāng)然的結(jié)果可能并不可信，實(shí)踐操作方能出真知，多動(dòng)手，是技術(shù)人的王道。

參考：

http://www.eygle.com/archives/2017/04/drop_partition_