Drop Partition Shows up as Insert
We are doing a drop partition on a table. We saw some blocked sessions due to the partition drop. When we checked what sql was being run by the blocker session it was showing up as an insert. Do you know why that is the case?
Here is a sample partition drop we ran. The table has global partitioned index on it.
--Drop statement
alter table XXXXX.XXXXXX drop partition SYS_P255637 update indexes;
--The query that showed up
insert /*+ RELATIONAL("XXXXX") PARALLEL("XXXXX",1) APPEND NESTED_TABLE_SET_SETID NO_REF_CASCADE */ into "XXXXX"."XXXXX" partition ("SYS_ P255637") (select /*+ RELATIONAL("XXXXX") PARALLEL("XXXXX",1) */ * from "XXXXX"."XXXXX" partition ("SYS_P255637") ) delete global inde xes