Geez, I guess there was a lot of answers that I hadn't scrolled to yet.

Joel Patterson
Database Administrator
joel.[Email address protected]
x72546
904 727-2546

-----Original Message-----
From: Rahul Chaudhari
[mailto:oracledba-ezmlmshield-x17254256.[Email address protected]
Sent: Tuesday, October 31, 2006 2:12 AM
To: LazyDBA Discussion
Subject: Re: Dropping the tables

select ' DROP TABLE '||tname||' CASCADE CONSTRAINTS;' from tab where
tabtype='TABLE'

This is the correct syntax for dropping

Regards,
RahulC

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


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