Re: delete a schema in Oracle 8 ?

From: Van Messner <vmessner_at_netaxis.com>
Date: Tue, 20 Jul 1999 18:13:22 -0400
Message-ID: <RC6l3.3041$t04.61160@typ31b.nn.bcandid.com>

DROP USER username CASCADE;

Then take a look at the Oracle 8 documentation - concepts manual.

WBoutros <wboutros_at_aol.com> wrote in message news:19990720175507.05670.00000304_at_ng-ch1.aol.com...
> how do you delete an entire schema in Oracle 8. I tried removing the
> tablespace, however, the schema still exists.
> In general I guess my question is, how do you completely clean up and
remove
> all traces of a set of tables. I imported some sample data with the access
> migration tool, and now want to clean that up completely. Thanks
>
Received on Tue Jul 20 1999 - 17:13:22 CDT