Here's the situation:
I have two Oracle 10g databases (with the same tables, etc.) that cannot be connected by network. At some regular intervals (say, once a day) I need to be able to update the data on database B to match that database A. Database B is for reading only, so there shouldn't be any changes to data made on it.
Since there's no network connection between them, I need to create some kind of file from the one that can be taken to the other and loaded easily. I'd like both exporting this file and importing it to the other database to be as fast as possible... ideally, it would only contain the minimum necessary information on exactly what changed since the last sync.
Obviously, I could do a full export of one database and replace the other with its data. However, this would take an unacceptable amount of time. I've also found some things about incremental export, but it seems like that is outdated and also exports all the data in any table that changed. This would be problematic since one particular table (that is very likely to change) contains large BLOBs and would take by far the most time to export and import fully.
I'm not a DBA so I don't have much expertise in this area. Is there anything well suited to doing this?