Thanks a lot to all. Is there any alternative to perform this task using OBJ$.


Regards,
Raj

----- Original Message -----
From: Thiyagaraj
To: LazyDBA Discussion
Sent: Tuesday, October 31, 2006 12:37 PM
Subject: Re: Dropping the tables


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
>



---------------------------------------------------------------------
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