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

Oracle LazyDBA home page