Re: How to drop an oracle database

From: ORACLE_DBA <vkb_at_kali.cs.wayne.edu>
Date: 22 Jun 1998 15:50:40 GMT
Message-ID: <01bd9df6$1839d1c0$fae809a2@smithjl.deco.com>

No that's basically it, you can also free memory by editing /etc/system file and reducing SHMMAX SEMMAX etc parameters.. if you are not going to use that additional memory for some other new database/instance..

All the best

Vijay K Banda

Opinions Expressed or mine only..

kchami_at_my-dejanews.com wrote in article <6mlsou$fh0$1_at_nnrp1.dejanews.com>...
> Hi,
>
> I need to drop one of my oracle databases (instance + db). Is there, in
> Oracle, any equivalent to other dbms' "DROP DATABASE" instruction?
>
> I have been suggested to drop manually, through the operating system,
after
> having brought the instance down:
> - the init_sid.ora parameter file
> - the redo logs
> - the control files
> - the archive logs
> - the data files.
> Am I missing something in this list?
>
> Is there a way to drop these all using a soft(ware?) way?
>
> Thank you,
>
> Karina.
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>
Received on Mon Jun 22 1998 - 10:50:40 CDT