Skip to Main Content
Forums

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!

dbms_job.sumit

Ran GAug 12 2013 — edited Aug 12 2013

Hi ,

I am running a job (ods.exec_wtl_proc) submitted with dbms_job.sumit. It basically loops through partitions and swaps them (using ALTER TABLE EXCHANGE PARTITION) between dwh.dwh_stocks_f_up and dwh.dwh_stocks_f, this goes via de unpartitioned table dwh.dw.

I cannot see any activitiy that explains this behavior.


Thanks,

Ran G.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 9 2013
Added on Aug 12 2013
#11g, #general-database-discussions, #oracle, #performance
5 comments
163 views