9 Replies Latest reply: Aug 2, 2012 4:51 PM by Tom Petrus RSS

    How to query blob from remote database dblink

      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