Stack Overflow
Stack Overflow

Questions tagged [direct-path]

7 questions
11
votes
2 answers

Is it possible to use direct path insertion with JDBC/Java?

We have an application written in C and Pro*C which inserts data from log files into an Oracle 11.2 database using host arrays and bulk insertion. This uses the APPEND and NOLOGGING hints to take advantage of direct path insertion and reduce the…
Burhan Ali
  • 2,258
  • 1
  • 28
  • 38
5
votes
1 answer

How do I parallel direct-path load using Oracle external tables?

Some years ago, Thomas Kyte said this (here): My favorite use of external tables: Load this really big file ASAP. In the past, setup the scripts to parallel direct path load. Coordinate the firing of said scripts. Review log files to make sure they…
Rudiger
  • 51
  • 1
  • 2
1
vote
0 answers

Can a direct path insert into a LOB column?

If my target table has a BLOB column in it, can I use direct path? I found this statement from Oracle: Supplemental logging is not enabled and the table does not have a LOB column I did not know if this was a statement with both conditions that…
johnny
  • 19,272
  • 52
  • 157
  • 259
1
vote
0 answers

How to use Direct Path in OCCI?

From the OCCI documentation https://docs.oracle.com/database/121/LNCPP/toc.htm, I cannot find an obvious API to use DirectPath, do I need call OCI api directly in the OCCI application?
zoe
  • 849
  • 6
  • 7
0
votes
3 answers

Can you using joins with direct path inserts?

I have tried to find examples but they are all simple with a single where clause. Here is the situation. I have a bunch of legacy data transferred from another database. I also have the "good" tables in that same database. I need to transfer…
johnny
  • 19,272
  • 52
  • 157
  • 259
0
votes
1 answer

Given a tree T = (V, E), find the direct path from a vertex v to vertex w

I'm stuck in my algorithm assignment which ask to find the direct path in a tree(V, E) with n vertices (acyclic indirect graph) from vertex v to vertex w in time complexity O(dist(v, w)). I have to find a preprocess (that runs in O(n)) to store some…
mini
  • 180
  • 10
-1
votes
2 answers

Direct-Path INSERT query generates ORA-00918 error

can you please explain why the error ORA-00918 is generated while executing this query INSERT INTO CLG_TEST_2 (CLG_TEST_2.record_id, CLG_TEST_2.chain_id, CLG_TEST_2.chain_n, CLG_TEST_2.contact_info) select * from ( SELECT 1, 1, 0, '2222' from…
C2S
  • 7
  • 3