> Dear all,
>
> Is there a way to drop all tables, indexes etc at once? I
now have to
> do it either manually following the right order so the error
message
> (ORA-02449: unique/primary keys in table referenced by
foreign keys)
> doesn't appear
> or via the Schema Manager (removing table one by one).
Several suggestions:
- if you have the right to do this and the script to
recreate the database, you could do a "drop database"
(it may be too radical);
- otherwise, use the great tool called "Toad" (Tool for
Oracle Application Developers, freeware version available
from www.toadsoft.com): it can automatically create a
scripts to recreate all the tables of a database
(in the right sequence of constraints). You can also
modify the script to keep only the DROP TABLE statements.
Opinion: Schema Manager and interactive tools are great,
but you still need to work with scripts to work fast and
be able to recreate what you have done. Toad is giving you
a lot of help to reach this.
Hope this helps
--
This answer is courtesy of QuestionExchange.com
http://www.questionexchange.com/showUsenetGuest.jhtml?ans_id=4886&cus_id=USENET&qtn_id=3976
Received on Tue Oct 12 1999 - 06:25:01 CDT
