Home » SQL & PL/SQL » SQL & PL/SQL » select and insert blob column using dblink
select and insert blob column using dblink [message #191850] Fri, 08 September 2006 06:38 Go to next message
dassudip
Messages: 22
Registered: February 2005
Location: Delhi
Junior Member

Hi,
I need to select blob column from remote database server using dblink and insert into local database.

remote database schema - db_source
destination schema - db_dest
(db_source and db_dest are identical)
database link - dl_dest

Now if I try:

INSERT
INTO db_dest
SELECT *
FROM db_source@dl_dest

This does not work. Can you please give me some alternate solution?

Regards,

Sudipta

Re: select and insert blob column using dblink [message #191882 is a reply to message #191850] Fri, 08 September 2006 08:10 Go to previous message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
There are o so many ways.....
How about doing it in Java, PHP, C ?
Or COPY in SQL*Plus?
Previous Topic: Displaying '&' in query
Next Topic: Changing backend of Crystal from SQL Server to Oracle
Goto Forum:
  


Current Time: Tue Aug 22 23:32:21 CDT 2017

Total time taken to generate the page: 0.02083 seconds