| regarding blob data [message #240825]
||Sat, 26 May 2007 03:54
Registered: May 2007
--How do we get blob data images from one database(1) table to another(2) over a db-link. I create a temporary table on 1 using:
create temp_table as select key,blob_image from table_having_blobs@mydblink;
(I will use this temp_table to populate other tables on the same database as temp_table as some complex joining is involved)
It works, but when no. of records increase the script gets stuck and i have to end it eventually.But is it the write way or is their some proper way to it?
--Also, I have two tables A and B having the same fields. A is filled with all the fields including the image(blob) field. B has the same data and rows as A except the image field is missing in the records. A & B have 3 fields making a primary key.
When i use the following query it gets stuck:
set (blobimage) = (select
from A orig
where orig.col1 = B.col1 and orig.col2 = B.col2 and
orig.col3 = B.col3)
where exists (select 1 from A where
A.col1 = B.col1 and A.col2 = B.col2 and
A.col3 = B.col3)
--col1,col2,col3 make up the primary key
if i use the same query to transfer any other field other than image it works fine and completes quickly.
Kindly advice on the above 2 issues. Thanks