RE:

[Farnsworth, Dave]

You can do a   DELETE USER User_Name CASCADE;   But this will get rid of a whole schema.   Dave -----Original Message----- From: Clinton Naude [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 22, 2002 4:33 AM To: Multiple recipients of list ORACLE-L Subject: What is the syntax to delete multiple objects, or more specifically multiple tables from a user in 1 go. I need to delete 50+ tables/objects without deleting them 1 by 1.   Thanks   Clint