Dropping All Tables

From: Michael J. Harper <mharper_at_well.sf.ca.us>
Date: Fri, 4 Sep 1992 00:11:16 GMT
Message-ID: <Bu11us.Fx0_at_well.sf.ca.us>

In a situation where you have a database class which has 30 students, each with their own Oracle logins, you end up with alot of tables at the end of the class. When the class is over, you want to remove any traces of the 30 students. So, you revoke resource & connect on all of them, but their tables persist!

What is the easiest way to remove all tables, views, synonyms, etc. owned by a particular user?

Michael J. Harper
mharper_at_well.sf.ca.us Received on Fri Sep 04 1992 - 02:11:16 CEST

Original text of this message