Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: dropping multiple tables belonging to a user

Re: dropping multiple tables belonging to a user

From: John Chiu <johnc_at_relsol.com>
Date: Tue, 05 Oct 1999 06:26:32 -0400
Message-ID: <37F9D258.9BE5B5BE@relsol.com>


write a sql script to drop tables one by one.

If you want to drop the user together with all objects belongs to that user: drop  user username cascade;

John Chiu
ocp
 

Verna Legaspi wrote:

How do you drop multiple tables?  Is it fairly simple?  I just need to
drop several tables that belong to a user.  What's the best way to do
this?
  Received on Tue Oct 05 1999 - 05:26:32 CDT

Original text of this message

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