Re: Oracle Schema Question

Friends wrote on 22-Mär-99 18:28:13:
>I am a programmer being trained to be a DBA, and have a question, Is
>there a way that we can delete or drop a schema from the database? I
>know we can drop tables and other stuff, but have not found any
>information on deleting or dropping schema's from any of the books that
>I have.

Hello Shanky,

try

drop user <schema name>;

If the schema is not empty, you will have to add the cascade clause. The statement then is something like this:

drop user <schema name> cascade;

>Appreciate any help.
>Shanky

Hope that helps,
Lothar

--

Lothar Armbrüster       | lothar.armbruester_at_rheingau.netsurf.de
Schulstr. 12            | lothar.armbruester_at_t-online.de
D-65375 Oestrich-Winkel |