Yes, I'll have to admit that when I was looking at some of them, that I
did not think that the authors actually ran the queries to see if they
worked. I know I didn't test the answers, (except mine).... Seemed
like a waste of time.

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

-----Original Message-----
From: Les Hollis
[mailto:oracledba-ezmlmshield-x42336641.[Email address protected]
Sent: Tuesday, October 31, 2006 9:26 AM
To: LazyDBA Discussion
Subject: Re: Dropping the tables

a lot of incorrect or incomplete answers




----- Original Message -----
From: "Joel" <oracledba-ezmlmshield-x69541233.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Tuesday, October 31, 2006 7:21 AM
Subject: RE: Dropping the tables


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