Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: drop database

Re: drop database

From: bjin <jinbo_at_hpsgns1.sgp.hp.com>
Date: Fri, 09 Apr 1999 17:17:15 +0800
Message-ID: <370DC59A.16DD94B3@hpsgns1.sgp.hp.com>


Hi Timpie,

"drop database link dblink_name" is the statement to drop database link. There is no sql statement to drop a database.

To drop database:
1. shutdown the instance
2. remove datafiles, logfiles, controlfiles, init.ora, password file, etc.

Hth
bjin

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 - 04:17:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US