Link to versioned tables from other schema
hi!
we are currently evaluating possible data synchronization mechanisms for a future database A that should use data from an existing database B.
option 1 is the simplest: export data from B, import in A and you're done. problems are of course the usual ones like hassle with import/export, how up-to-date the data is, etc.
however we are more interested in option 2: link to the tables in B from A. if we are not wrong here we could establish this by using dblink and synonyms.
importand fact is, the tables in B are versioned with OWM. is it in any way possible to link to those in that case? and if so, how would workspace/savepoint selection be handled?
we suspect it's not possible, at least not if the tables in database A aren't versioned as well. or one would need to omit real foreign keys when referencing versioned tables in B from A, which isn't exactly good either.
thanks for any hints in advance!
regards,
Andreas