Skip to Main Content
Forums

SQL & PL/SQL

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!

delete from table@dblink

marcoAug 12 2013 — edited Aug 12 2013

Hi all,

my need is to find sane way to perform


delete from destination_table@dblink where adate = trunc(sysdate)

The quantity of rows in destination_table@dblink is 7 740 434.

I tried also to perform

select count(1) from destination_table@dblink where adate = trunc(sysdate)

before deleting (delete only if those records are present), but the result is the same, script stucks for insane time.

Maybe I should know some clever methods of working with tables @ dblink.

Any ideas are appreciated.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 9 2013
Added on Aug 12 2013
#delete
1 comment
1,275 views