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: statement for dropping all objects of a certain user ?

Re: statement for dropping all objects of a certain user ?

From: Bo Lu <bo.lu_at_m.cc.utah.edu>
Date: 1997/05/04
Message-ID: <336D1223.FCE@m.cc.utah.edu>#1/1 







Michael Agbaglo wrote:


> 

> statement should be processable in sql-plus -thanks.




User SQL*plus generate a *.sql script. 


"select 'drop ' || object_type || ' ' || object_name || ';' 
from all_objects where owner = 'xxx'".


-- 
Bo Lu
Senior DBA
University of Utah Hospital
801-581-5964


Received on Sun May 04 1997 - 00:00:00 CDT












Original text of this message













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