Oracle Error ORA-12353: secondary stored object cannot reference remote object

Oracle Error Message

ORA-12353: secondary stored object cannot reference remote object

Reason for the Error

You tried to either select from a remote view or execute a remote procedure which references an object on another database. Since the remote view or procedure is on a secondary database, an additional reference to another database cannot be done.

Solution

Choose a different object to reference or change the remote view or procedure so that it does not reference another database.