12C新特性:truncate/drop多个表分区

SQL> ALTER TABLE t_whs_p truncate PARTITION p6 ,p7 ,p8 ,p9 ,p10;

Table truncated.

SQL> ALTER TABLE t_whs_p drop PARTITION p6 ,p7 ,p8 ,p9 ,p10;

Table altered.

SQL>  ALTER TABLE t_whs_p truncate PARTITION p6 ,p7 ,p8 ,p9 ,p10;
 ALTER TABLE t_whs_p truncate PARTITION p6 ,p7 ,p8 ,p9 ,p10
                                        *
ERROR at line 1:
ORA-02149: Specified partition does not exist

Related Posts