Its possible over dblink.

For this you need the Transparent Gateway connection which almost supports all the functionality over db's using dblink. To install this needs separate Oracle license.

The other way is Generic connectivity which has limitations, still you can do most with an ODBC drivers installed which has capability to support multiple active ODBC cursors.

On most Oracle server you have the generic connectivity. Check your db what way it connects to remote db. Main restrictions of using Generic connectivity is "BLOB/CLOB data cannot be read through passthrough queries", "cannot involve in 2 phase commit". For further ref: Metalink

I have a remote database with blob column tables and they populate the local db through triggers, procedures, and ofcourse dblink. I have a licensed TG connection.

Hope this helps the DBA community.