Re: Deleting Database..

From: Paul Drake <paled_at_home.com>
Date: Mon, 19 Nov 2001 06:29:48 GMT
Message-ID: <3BF8A6E4.EEFC0409@home.com>

Giovanni Azua wrote:
>
> Hi all,
>
> I would like to delete a couple of test Databases I created wih the
> Oracle Database Assistant. The problem is that I don't know what
> are the internal passwords, I have tried all possibilities, 'oss',
> 'system/manager' etc

delete the existing password files and recreate them. at a command prompt, type

C:\> oradim

and the help page will be displayed.

> This is just kind of another question.... I would also like to know
> if there is somthing like this:
>
> DELETE FROM user_tables WHERE tablespace_name='USR'
>
> I know its wrong like that but would like to know if there is a way
> for deleting all tables in a DB pertaining to one namespace.
>
> Thanks in advance!
> Giovanni

spool this and execute it:

select 'drop table '||table_name||' cascade constraints;' from user_tables
where tablespace_name='USR'
/

Paul Received on Mon Nov 19 2001 - 00:29:48 CST