Re: Deleting User Tables

From: C. <c_ferguson_at_rationalconcepts.com>
Date: Fri, 25 Jun 1999 09:52:13 -0700
Message-ID: <3773B3BC.5EEC7D9A@rationalconcepts.com>

Hi Mark,
You could write a stored proc that uses the query select table_name from all_tables where owner = 'whoever' and loop through and drop each one. Just an idea...
Cindy Ferguson, Rational Concepts,INC

Mark Schenkel wrote:

> What is the best way to delete all of a user's tables? Right now I have
> been dropping the user and then recreating the user.
>
> I want to drop all of the user's tables because I am using IMP80 to
> overwrite all of the tables. Is there a way to have IMP80 overwrite all
> of the existing tables?
>
> Thanks, Mark.
Received on Fri Jun 25 1999 - 11:52:13 CDT