| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE:writing massive loading, processing process
Using stored procedures I am bringing in data into a temporary table, going through a series of edits, converting, transforming with updates back to that table so I can keep it for auditing purposes and make sure I don't impact the OLTP users on the primary tables. Then I pull a sequence, update the sequence and load the already checked and prepped data into the base tables.
I know that many of you have done this before it certainly doesn't seem anything but common sense. However, I was wondering if there were some ideas/papers on stored proces. best practices - ideas for "tightening" the code using functions yadayada.
I have been using Steve F... book on best practices but I was wondering if there was anyother good on-line references for stored proc. design and best practices.
Thanks,
Paula
 |
 |