This content has been marked as final. Show 1 reply
You can use links/synonyms. GotoWorkspace works the same as it would for the local database. You just have to execute it on the remote database.
SQL> exec dbms_wm.GotoWorkspace@dblink('Workspace1') ;
You should be able to use tables from different databases within the same query. However, there isn't any support for foreign key constraints where the tables are defined on different databases and only the child tables is versioned. In the case, the parent table needs to be part of the same db as the child.