Solved! Go to Solution.
My apologies, I had not been monitoring this and have since changed jobs. However, I can answer that question, in that on the remote database the sql that you write to select from the Geo-aware database should not include the shape field. The ArcSDE multi-versioned view is just a view not a materialized view.
For example: select attr1, attr2 from geoAwareDatabase@remote_oracle would be good.
Not Good: select attr1, attr2, shape from geoAwareDatabae@remote_oracle;
Going through the DBLink would not work. Now with updates and upgrades that may have changed.