OraFAQ Forum: Server Administration » Re: Command to drop all tables???

Home » RDBMS Server » Server Administration » Re: Command to drop all tables???

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Command to drop all tables??? [message #371137]

Tue, 05 September 2000 14:35

aj_7786
Messages: 2
Registered: September 2000

Junior Member

Thank you

Report message to a moderator

Re: Command to drop all tables??? [message #371153 is a reply to message #371137]

Thu, 07 September 2000 14:06

Salman Khan
Messages: 51
Registered: September 2000

Member

There is no command to drop all the tables at once. But you can create your sql statments and drop all the tables. for example

Select 'Drop Table '||tname||';' from tab

spool the above statement output and run it.

Bye
Salman Khan
DBA

Report message to a moderator

Previous Topic:	3~5 seconds to connect to oracle
Next Topic:	SQL Output printing on HP Laser Jet printer (4000 N Seris)...

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 11:09:04 CST 2024