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
>
> I have searched in the documentation and can't find what is that
> internal Database password and always get an invalid username/
> password error from the Database Assistant when trying to delete
> an existing DB.
>
> **********************************************************
>
> 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
Do you mean database (the physical files that comprise an instance) or a
schema within an instance?
To delete a schema, 'DROP USER xx CASCADE;'
To delete the physical files, 'rm -f xxx'
--
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.
Received on Sun Nov 18 2001 - 15:24:40 CST
