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: alter schema name?

Re: alter schema name?

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Wed, 22 Dec 2004 04:54:30 +1100
Message-ID: <41c86357$0$4534$afc38c87@news.optusnet.com.au> 





hastenthunder wrote:


> Is there any way in Oracle 10g to alter the schema name from x to y?

> 

> 





Yup. Same method as we used in 7, 8 and 9: export, drop, and on the 
import use FROMUSER=X TOUSER=Y.



But is there an 'alter schema' command? No.



Regards


HJR

Received on Tue Dec 21 2004 - 11:54:30 CST












Original text of this message













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