Oracle Database Discussions

Hi,

I work for an integration company and right now we are putting together an application that is moving a small subset of data from one db to another. I have created a db link to move the data. However, when I try to compile the procedure, that moves the data, into the database, the compile fails and I am given the following error:

ORA-02083: database name has illegal character ‘-‘.

The instances I’m developing/testing to are on the same machine, which is a Solaris X86 machine and the Oracle version is 8.1.7.

Now 2 things. If I do a simple query like the one below using SQL*PLUS, the link works fine.

Select sysdate
From dual@<dblink_name>;

The other thing is the domain name does in fact have a ‘-‘ in it, but I have removed the domain name from everyplace I can thing of from Oracle; i.e. tnsnames, init.ora file, etc.

Does anyone have any ideas?

Thanks,
Roger Christophel