Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DB LINK and ORA-00933: SQL command not properly ended
Did you try using quotes like
drop database link "NAME.SERVER.COM";
hope this helps.
regards
Anil
In article <8ama1a$a4e$1_at_nnrp1.deja.com>,
michael_at_tantalus.com wrote:
> 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.
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Mar 15 2000 - 00:00:00 CST