Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Insert Select on same partition: RELATIONAL() - DELETE GLOBAL INDEX

3056262Oct 22 2015 — edited Oct 22 2015

Hi all,

I found on v$sqlarea following statament:

insert /*+ RELATIONAL("TABLENAME") PARALLEL("TABLENAME", 1) APPEND NESTED_TABLE_SET_SETID NO_REF_CASCADE */

into "SCHEMA"."TABLENAME" partition ("DAY20151015")

(

select /*+ RELATIONAL("TABLENAME") PARALLEL("TABLENAME", 1) */

from "SCHEMA"."TABLENAME" partition ("DAY20151015")

)

delete global indexes

It is a query that reads and writes the same data on the same partition!!!!!

I think it is generated by Oracle, but I don't undestand what it does.

Can you give me some explanation or help about that query?

Thank a lot

This post has been answered by unknown-7404 on Oct 22 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 19 2015

Added on Oct 22 2015

#general-database-discussions

2 comments

2,614 views