we can do that by qriting the PL/SQL code.
----- Original Message -----
From: "Raj " <oracledba-ezmlmshield-x93527208.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Tuesday, October 31, 2006 12:19 PM
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
>


Oracle LazyDBA home page