Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to delete a user and his table?
drop user <username> cascade;
HTH,
Mario.
"ftp" <shyan_at_cse.cuhk.edu.hk> wrote in message
news:9ot6tu$klf$3_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?
>
> --
Received on Wed Sep 26 2001 - 13:52:14 CDT