This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / 请教如何在Oracle中Copy Blob.试了命令 COPY FROM ... INSERT ... USING SELECT ... 和Stored Procedure, Copy几个记录测试可以，真一运行就出错，因有6万记录，每个Blob 40K左右，请问Oracle中有没有关于变量大小设置.
-smallguy(oops);
2003-7-19
(#1294342@0)
-
When do you commit? For huge records, you need to commit frequently.
-ling7199(Michaell);
2003-7-19
(#1294670@0)
-
I tried commit every one record. But it still raised error when it read record 12 in which the size of blob is around 40K. It copied from record 1 to 11 properly in which the size of blob are around 30K.
-smallguy(oops);
2003-7-19
(#1294994@0)
-
According to the document, in PL_SQL, the buffer size is only 32K. So when you use DBMS_LOB, the amount you read also should limited to 32K. Good Luck.Maybe the 32K can be changed by setting the SGA parameter in the init.ora.(never try it before, just a idea).
-ling7199(Michaell);
2003-7-20
{109}
(#1295835@0)
-
Thanks a lot. I will try it next week after my vacation, and will post the result here. thanks again.
-smallguy(oops);
2003-7-22
(#1299068@0)
-
Try DBMS_LOB package
-jin_ting(jy);
2003-7-20
(#1295656@0)
-
Never tried DBMS_LOB package before. Could you please describe it more detail? Is this a utility?
-smallguy(oops);
2003-7-22
(#1299071@0)
-
Have a look at the Oracle online document: under the application developer's guide -- Large object(LOBs) using PL-SQL, there are one example to copy LOB to LOB. You can have a look.
-ling7199(Michaell);
2003-7-24
(#1301888@0)