Database DataWarehousing (MOSC)

MOSC Banner

Drop Partition Shows up as Insert

edited Mar 25, 2014 12:00PM in Database DataWarehousing (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center