Re: script to delete multiple tables

I do not know how you can read the files from a spreadsheet in an easy way (not without using sql*loader or utl_file), but I often use this script for e.g. analyzing all my tables:

• start of script -- spool analyze_all.sql select 'analyze table '||table_name||' estimate statistics;' from user_Tables; spool off _at_analyze_all.sql --
• end of script

Perhaps you can modify this script or combine it with other ideas to find a way.

Good luck!

Patrick Sinke
Cap Gemini Ernst&Young, Sector Financial Services.

Jeanneli <jeanneli_at_aol.com> schreef in berichtnieuws 20010506120819.25638.00000833_at_ng-mh1.aol.com...
> Hi,
>
> Need someone's help here. I have a speadsheet that have 300 table names. I
 want
> a SQL script to read the file and delete those tables in a single
 database.
>
> Any one has the similar codes, or at least point me to the right
 direction? I
> am new to oracle :(.
>
> Thanks so much.
> Jeanne
Received on Mon May 07 2001 - 08:55:55 CEST