Re: [Question]drop all tables owned by a user

From: Alan <not.me_at_rcn.com>
Date: Tue, 25 Jan 2005 23:34:52 -0500
Message-ID: <35okvsF4pb5gvU1@individual.net>

"anonymous" <newbie_tw_at_yahoo.com.tw> wrote in message news:7be59b3a.0501251949.11c56503_at_posting.google.com...
> Is it possible to drop all tables by user who owns those tables in one
> sqlstatement? for instance, I have a user who has A, B, C ... Z
> tables.
> Then I want to drop all those tables by sql statement. is it possible?
> If yes, how?
> I appreciate any suggestion, sincerely.

Has your instructor mentioned creating SQL from SQL? Received on Tue Jan 25 2005 - 22:34:52 CST

This message: [ Message body ]
Next message: stefan.roesch_at_gmail.com: "Re: Oracle RunInstaller fails on 10g for zLinux"
Previous message: Fuzzy Greybeard: "Re: [Question]drop all tables owned by a user"
In reply to: anonymous: "[Question]drop all tables owned by a user"
Next in thread: Connor McDonald: "Re: [Question]drop all tables owned by a user"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US