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 -> Chown for Oracle ?? Giving schema objects to other user ?

Chown for Oracle ?? Giving schema objects to other user ?

From: Peter Gross <peter_at_number13.demon.co.uk>
Date: Wed, 4 Nov 1998 16:20:28 -0000
Message-ID: <910196581.16229.0.nnrp-01.c1edb16f@news.demon.co.uk> 





One of our developers has imported there work into the SYSTEM user by
mistake. Before realising a number of changes have been made to the objects
(meaning that I can't just drop and then re-import the objects).



Can anyone suggest how I (selectively) copy the objects from the SYSTEM user
to the DEV user ?



I was thinking that CREATE AS might be an option, but surely this wont be of
use for the other objects such as synonyms, constraints, indexes, etc.



Any assistance greatfully received.




Received on Wed Nov 04 1998 - 10:20:28 CST












Original text of this message













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