secondary stored object cannot reference remote object

Solution ID:ORA-12353

Type: Oracle

Cause

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.

Actions

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

Try the following links for this error:


http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12300.htm


https://community.oracle.com/message/1327135


Browse all solutions to database errors from Oracle, MS SQL, or MySQL