Home » SQL & PL/SQL » SQL & PL/SQL » regarding blob data
icon5.gif  regarding blob data [message #240825] Sat, 26 May 2007 03:54
Messages: 2
Registered: May 2007
Junior Member

--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:

update B
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
Previous Topic: coalesce puzzle
Next Topic: Database Design
Goto Forum:

Current Time: Mon Aug 21 14:53:03 CDT 2017

Total time taken to generate the page: 0.13066 seconds