Re: How to delete a user and his table?
From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 26 Sep 2001 20:42:13 +0200
Message-ID: <9otj7d$eqqgq$1_at_ID-62141.news.dfncis.de>
Date: Wed, 26 Sep 2001 20:42:13 +0200
Message-ID: <9otj7d$eqqgq$1_at_ID-62141.news.dfncis.de>
[Quoted] "ftp" <shyan_at_cse.cuhk.edu.hk> wrote in message
news:9ot6t3$klf$1_at_eng-ser1.erg.cuhk.edu.hk...
> drop user usernmae;
> cannot delete the user if he/she has created tables.
> How to drop the user and his/her tables?
>
> --
drop user <username> cascade
Are you planning to ask the syntax of *all* sql commands from this group and [Quoted] never to study any manual?
Regards,
Sybrand Bakker, Senior Oracle DBA Received on Wed Sep 26 2001 - 20:42:13 CEST