SQL & PL/SQL

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!

sqlplus ORA-02083: database name has illegal character '-'

451271Jun 30 2010 — edited Jun 30 2010

Hello,

my database is 9.2.0.1.0

I have a problem with this error sqlplus ORA-02083: database name has illegal character '-' and my problem is:
- a have made database link between two servers and it is working OK
- if I run select from SQLPLUS from any tables in that database link it is also working OK

-but if I try to create package (using same query from tables that are working with select statement in SQLPUS) I get this error
sqlplus ORA-02083: database name has illegal character '-'

I tried SELECT * FROM DBA_DB_LINKS,
and I get :
OWNER DB_LINK USER SERVICE CREATED

PUBLIC DILERJI DILER DILERJI 30.06.10

so it is only database link and I chacked if it is maby open
ALTER SESSION CLOSE DATABASE LINK dilerji;
and it is not
ORA-02081: database link is not open

So can anyone help me? Thanks

Edited by: Jero on Jun 30, 2010 12:49 PM

This post has been answered by Hoek on Jun 30 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 28 2010

Added on Jun 30 2010

13 comments

7,491 views