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 all objects for an user

Re: dropping all objects for an user

From: Kjetil Nordstrand <spammers_at_get-lost.com>
Date: Mon, 26 Apr 1999 14:14:21 +0200
Message-ID: <372458f4@news.sto.telegate.se> 





No, write a script that will loop thru USER_OBJECTS and get the cascading
right.




--


Kjetil Nordstrand


Karlstad, Sweden



dfp1 skrev i meddelandet <7fkgru$her$1_at_demon.uunet.ca>...


>Hi,


>


>Is there a SQL statement that will let me drop all the objects in an users


>schema, but preserve the user (with privileges etc. intact)?


>


>Thanks,


>Dinesh


>


>




Received on Mon Apr 26 1999 - 07:14:21 CDT












Original text of this message













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