DB LINK and ORA-00933: SQL command not properly ended

From: <michael_at_tantalus.com>
Date: 2000/03/14
Message-ID: <8ama1a$a4e$1@nnrp1.deja.com>#1/1

Can somebody help me with this. I am trying to delete a database link, which is not public. The name of the link has 3 components, like name.server.com. When I execute :

drop database link name.server.com;

I received an error ORA-00933 and an asterisk under the first dot. This is strange because the dot can be part of the database link name. I think that the only reason can be that I imported this schema from a 7.3.4 database to a 8.0.5 database. We don't have a backup so I don't know if the character sets are different. May this is the reason. If that's the case then why I am able the query all the database links.

Thanks ... Michael

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Mar 14 2000 - 00:00:00 CST