APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to query blob from remote database dblink

GhanaApexDeveloperJul 23 2012 — edited Aug 2 2012

can anyone help me on a good way to query blob contents from a remote database using dblinks.
i have a table with about 15million records consisting of xml and pictures in blob and i want to query this table using dblink.
how can i go about since it is difficult to query blob contents from a remote database.
migrating the table is not an option since it's more than 1tb in size and i don't have that kind of space on the querying server.
oracle 11g release 2 on rhel 5.7
Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 30 2012

Added on Jul 23 2012

#11g, #apex, #apex-discussions, #blob, #connection, #database, #dba, #plsql

9 comments

6,650 views