Re: Script to drop all the tables

spool drop.sql
select 'drop table '||table_name||';' from user_tables order by table_name; select 'drop sequence '||sequence_name||';' from user_sequences order by sequence_name;
spool off
_at_drop.sql
Or you could write a stored procedure to do it using dynamic sql. "Darwin Ling" <darwin_ling_at_hotmail.com> wrote in message news:2AAy5.11166$WK6.178092_at_typhoon.austin.rr.com...
> I would like to write a script to drop all tables and sequences that
 belong
> to a user in Oracle 8i
>
> What would be the easiest way to do this instead of doing
> drop table xxx explicitly for all tables?
>
>
>
>
Received on Thu Sep 21 2000 - 00:00:00 CEST