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 -> fastest way to drop a user

fastest way to drop a user

From: Kåre Sangolt <kare.sangolt_at_ttyl.com>
Date: Tue, 27 Aug 2002 12:44:58 GMT
Message-ID: <evKa9.14376$sR2.267200@news4.ulv.nextra.no> 





Hi,



anyone having an opinion on what is the fastest way to drop a user ?. In our
environment, the user is schema owner of thousands of object, including
tables and indexes. The user has its own tablespace, that can be drop'ed
with no consequences to other users. If I drop the user cascade this takes
"ours" to finish. Anyone having suggestion / ideas of what could be the
fastest way to drop the user ?



best regards


Kåre.
Received on Tue Aug 27 2002 - 07:44:58 CDT












Original text of this message













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