Hi Raj

Create a script

Set lines 1200 pages 1200

Spool drop_tables.lst

Select 'drop table '|| owner || '.' || table_name || ';'
from user_tables
WHERE owner=XYZ
/
@drop_tables.lst


Thanks
Ezekiel


-----Original Message-----
From: Raj
[mailto:oracledba-ezmlmshield-x93527208.[Email address protected]
Sent: 31 October 2006 08:49 AM
To: LazyDBA Discussion
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

--------------------------------------------------------------------------------
Please note: This e-mail and its contents are subject to a disclaimer
which can be viewed at http://www.woolworths.co.za/disclaimer. Should
you be unable to access the link please e-mail [Email address protected]
and a copy of the disclaimer will be e-mailed to you.



Oracle LazyDBA home page