Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create synonym for numeric username

mwrfApr 1 2011 — edited Apr 1 2011

Hi,

What is the correct way to create a synonym for a user with a numeric only username?
For example:

(a) Fails
create synonym 325232.table_name for table_name;
ORA-00995: missing or invalid synonym identifier

(b) Fails
create synonym '325232'.core_menu_option for core_menu_option;
ORA-00995: missing or invalid synonym identifier

(c) Creates synonym for current user, i.e. 325232.core_menu_option is the the current schema
create synonym "325232.core_menu_option" for core_menu_option;

This must be possible? I don't have control over the username, so can't change it.
Anyone any ideas?

DB version 10.2.0.4

Thanks,

Edited by: mwrf on Apr 1, 2011 3:43 AM

This post has been answered by orafad on Apr 1 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 29 2011

Added on Apr 1 2011

#general-database-discussions

4 comments

863 views