query blob from remote database dblink
Hi,
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
the remote blob table looks lik this:
create table biometric (id varchar2(10), facialimage blob, fingerscans blob);
i'm only need to query the id and facialimage columns from my local database.
Thanks.