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!

Procedure to update tables from temp tables

salibcsMar 15 2012 — edited Mar 15 2012

I'm a new DBA working with a group of new oracle developers... one has written a procedure to update table data from temp tables. the temp tables are populated from files out in an oracle directory.

When we try and run this procedure, it just runs and runs and runs... total number of rows to update in tables: ~20,000

I'm trying, as the DBA, to help them figure out why it's taking so long.... it shouldn't take this long to update this data.

Here is a link to the Code -> http://dl.dropbox.com/u/53598/load_data.txt

Edited by: salibcs on Mar 14, 2012 11:02 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 12 2012

Added on Mar 15 2012

5 comments

904 views