Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*Loader in direct path load
"viktor" <vikingil_at_yahoo.com> wrote in message
news:946871c0.0306220456.18397c72_at_posting.google.com...
> Hi All,
> I have the following problem.
> We are using SQL*Loader in conventional mode.
> I want to use the direct mode in order to improve the performance.
> Does any one can tell me if there are any problems with the following:
> 1. Issuing select / insert/ delete on the table (which has index)
> during the direct path load operation?
> 2. Is the SQL loader operation is atomic from user point of view
> meaning might he receive partial data from the load when performing
> "select" during the index update / high-water mark update?
> If not how can it be modified to be atomic? Should I use staging
> tables? and How do I use them - I happened to stumble about this issue
> in one article but I don't know how it works (yet :-) ).
> 3. If there is no way to make SQL loader operation atomic how can user
> be prevented from accessing to the table during the load?
> 4. I think users might need to remove old / bad data from time to time
> might it cause problems during direct path load operation.
> 5. Any other known problems when using SQL*Loader?
> Thanks ,
> Viktor
Wow, lots of questions!! Here is a link that may help
http://storacle.princeton.edu:9001/oracle8-doc/server.805/a58244/ch04.htm#17 74
Spark Received on Mon Jun 23 2003 - 04:40:18 CDT