SELECT 'drop table '||object_name||' cascade constraints;' FROM OBJ
WHERE object_type='TABLE'

Regards,
RahulC

----- Original Message -----
From: "Raj " <oracledba-ezmlmshield-x64700837.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Tuesday, October 31, 2006 12:52 PM
Subject: Re: Dropping the tables


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