| unable to create public synonym [message #508504] |
Sun, 22 May 2011 11:28  |
lg123
Messages: 225
Registered: August 2008
|
Senior Member |
|
|
I have exported and imported a schema from one server to another. In the source schema, I have a public synonym. I do not know the name of that synonym. In the destination schema, the public synonym is missing. How to create the public synonym which is missing in the destination database?
In the source, I queried dba_synonyms, all_synonyms... but it returns no rows selected.
[EDITED by LF: fixed topic title typo; was "synymym"]
[Updated on: Mon, 23 May 2011 01:23] by Moderator Report message to a moderator |
|
|
|
| Re: unable to create public synymym [message #508507 is a reply to message #508504] |
Sun, 22 May 2011 12:02  |
 |
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Quote:In the source, I queried dba_synonyms, all_synonyms... but it returns no rows selected.
So either it does not exist, either you you wrongly queried.
Schema export does not contain the public synonyms this is the expected behaviour.
As you are in 11.2 use data pump instead then you can use the INCLUDE parameter to add the public synonyms.
By the way, it is not a good idea to use public synonyms, envisage to convert them to private ones.
Regards
Michel
[Updated on: Sun, 22 May 2011 12:02] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
