Re: Deleting User Tables

From: tmgn <tmgn_at_excite.com>
Date: Fri, 25 Jun 1999 12:54:30 -0400
Message-ID: <7l0ce7$mk3$1@ffx2nh3.news.uu.net>

There is no Single command to delete all of the User's tables. I mostly drop&Recreate the User .

You can also generate dynamic Sql to delete only the Useer's Tables..like

spool drop_all_tbls.sql
Select 'drop table '||table_name||';' from user_tables; spool off
You may need to take care of the Constraints etc..But I Personally prefer Recreating the User..

Or You can also Truncate the Tables(taking care of the Constraints) and then do Import with IGNORE=Y option

-Thiru
Mark Schenkel <mschenkel_at_alpinesoftware.com> wrote in message news:37738368.F2A7BC44_at_alpinesoftware.com...
> 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:54:30 CDT