Inserting and updating long lob colum Xxx live chat ohne anmeldung
one field data type is LONG in first DB table, Same field data type in other DB is CLOB.
i used TO_LOB function to convert from LONG to CLOB data type.
Question: I have a table with a CLOB column (XMLTYPE datatype) and I want to know the best way to do an insert into this large object column.
So the SQL insert basically inserts a record with new XML, and a SQL updated replaces the old XML.
A DELETE statement on the other hand is executed serially as indicated in the note section of the plan.
Answer: When dealing with large objects, where are relatively few tuning options other than using a large enough blocksize to ensure that the XMLTYPE column does not fragment onto multiple data blocks.This book includes scripts and tools to hypercharge Oracle 11g performance and you can buy it for 30% off directly from the publisher.I was looking for a query which picks data from a table having Blob column and update a table having LONG RAW column.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.