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
Messages: 22
Registered: February 2005
Location: Delhi
Junior Member

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:

INTO db_dest
FROM db_source@dl_dest

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



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
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: Check the remote database status
Next Topic: PLS-00103: Encountered the symbol "ORDER" when expecting one ofthe following: ;
Goto Forum:

Current Time: Mon Jun 26 00:11:50 CDT 2017

Total time taken to generate the page: 0.19469 seconds