Problema trying to recreate synonym DUAL

Asked Aug 03 '16 at 14:57

Active Aug 03 '16 at 14:57

Viewed 85 times

In this link How to recreate public synonym "DUAL"? I've the same problem with one diference.

I executed this comand: CREATE OR REPLACE PUBLIC SYNONYM "DUAL" FOR "DUAL"

CREATING SO A "LOOPING CHAIN OF SYNONYMS". SO A REMOVE THE SYNONYM.

NOW MY PROBLEMA IS: The SCHEMA "exemple" can't connect in DUAL. (select * from dual) only can doing (select * from sys.dual).

We are trying to recreting the SYNONYMS but nothing are working. Someone can help me?

edited May 23 '17 at 12:14

Community

asked Aug 03 '16 at 14:57

1

With which user did you run the command? – Aleksej Aug 03 '16 at 15:14
take at look at this post it may help http://stackoverflow.com/questions/30504918/how-to-recreate-public-synonym-dual – davegreen100 Aug 03 '16 at 15:38

0 Answers0