Hi
just run this script on the user schema that you want to drop his/her tables:

SELECT ' DROP TABLE ' || tname || ' ;' from tab ;

this will generate drop statement for all his/her tables so either you save the result in file or copy the result to the editor

Thanks
Bashar Shannak
Maktoob Inc
>
>
>
>
> ----- Original Message -----
> From: Raj "oracledba-ezmlmshield-x93527208.[Email address protected]
> To: LazyDBA Discussion "[Email address protected]
> Date: 06:57 AM
> Subject: Dropping the tables
>
>
>
> Hello All,
>
>
>
> Kindly let me know how can we drop all the tables owned by a user without
> dropping the user.
>
>
>
>
>
> Kind regards,
>
> Raj
>
>
>
>
>
> ---------------------------------------------------------------------
>
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>
> To post a dba job: http://jobs.lazydba.com
>
> To Subscribe : http://www.LazyDBA.com
>
> To unsubscribe: http://www.lazydba.com/unsubscribe.html


Bashar Shannak
Database Administrator
Maktoob Inc.


_________________________________________________
Create your album and Share the best photos EVER with Maktoob Photo Album!
http://www.maktoob.com/photos

Oracle LazyDBA home page