Inserting and updating long lob colum singles dating events bristol
This example shows that parallel DML is allowed on a partitioned table with LOB columns.V$PQ_SESSTAT shows we get a DOP of 4 even though the plan shows a DOP of 8, that is because the table has 4 partitions.
i am trying insert data from one DB to other DB table.
SUBSTR(SOFTWARE_FILE, 4000) SOFTWARE_FILE, SOFTWARE_TYPE from APPDBA. QA_SOFTWARE_DUMMY_TEST ; PL/SQL will only read/write the first 32k of a LONG RAW and SQL will convert the column as a RAW so will only deal with the first 2000 bytes.
You can use java to access LONG RAW columns directly from the DB, as demonstrated in the question "Get the LENGTH of a LONG RAW".
Also, super-fast storage makes a big difference for inserts, and SSD have do well over 100,000 rows per second insert rates.
Here are the speed options for various insert methods: When storing a LOB, you can either load it inline, or leave it in a flat file and use BFILE: The landmark book "Advanced Oracle SQL Tuning The Definitive Reference" is filled with valuable information on Oracle SQL Tuning.