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 -> The fastest way of droping a schema???

The fastest way of droping a schema???

From: Alvin <agonzalezsanQUITA_at_ESTOnexo.es>
Date: Wed, 18 Apr 2001 17:07:01 +0200
Message-ID: <9bka32$e5j$1@talia.mad.ttd.net> 






I'd like to know the fastest way of droping a schema, that's to say: The
objects of an user, the user, the defaut tablespace and the datafiles
asociated.


I usually use the "DROP USER XXX CASCADE CONSTRAINTS", etc but it's very
slow.


Do you know some other way??


Thank in advance and sorry for my english.
Received on Wed Apr 18 2001 - 10:07:01 CDT












Original text of this message













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