Re: drop database

FIRST OF ALL BE CAREFUL If you are wanting to physically remove the Oracle Database and Instance from the machine, ONCE AND FOR ALL, then you need to (assuming Unix), update the /etc/oratab file and remove the SID's entry, Update the TNSNAMES.ORA / LISTENER.ORA files and remove the SID's entry, and then remove the init.ora file along with all the data files that constitute the database.

If however, you are wanting to drop a Database Link, then the command is 'drop database link <linkname>'.

There is no such Oracle Command to perform a 'DROP DATABASE', to my knowledge.

BE CAREFUL
Andrew

Timpie wrote:

> Hey there,
>
> I'm trying to drop a test database but can't seem to do it.
> Running Oracle version 7.3.2. with the command
> drop database test2
> Oracle responds with
> ORA-02026: missing LINK keyword
>
> Then I tried : drop database link netid;
> to which oracle says
> ORA-2083: a loopback database link must have a connection qualifier
>
> select from dba_db_links doesn't return anything.
>
> Anyone ?
>
> Thanks
Received on Fri Apr 09 1999 - 00:00:00 CDT