ORA-65040: operation not allowed from within a pluggable database

背景：

        Oracle 12c数据库，想删除PDB中SYS.WRI$_OPTSTAT_HISTGRM_HISTORY表的一些分区，通过sqlplus进入pdb，执行删除语句报错。

SQL> alter table  WRI$_OPTSTAT_HISTGRM_HISTORY drop partition SYS_P295539;
alter table  WRI$_OPTSTAT_HISTGRM_HISTORY drop partition SYS_P295539
*
ERROR at line 1:
ORA-65040: operation not allowed from within a pluggable database

解决办法：

       使用_oracle_scripts参数

SQL> alter session set "_oracle_script"=true;

Session altered.

SQL> alter table  WRI$_OPTSTAT_HISTGRM_HISTORY drop partition SYS_P295539;

Table altered.

SQL> alter table  WRI$_OPTSTAT_HISTGRM_HISTORY drop partition SYS_P295544 update indexes;

Table altered.