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 -> How to rename a schema

How to rename a schema

From: Timmy Sin <tswsin_at_yahoo.com>
Date: Wed, 19 Mar 2003 18:29:52 +0800
Message-ID: <b59gr0$f51$1@news.hk.linkage.net> 





Hi All,



What is the fastest method to rename a schema with public synonym? The
scenario is as follows.



I have a database named dev1 with schema dev1owner. This schema owns all the
tables. View and public synonym are created for other schema to access the
tables.



Another database dev2 is cloned from dev1. Now I want to change the schema
dev1owner in the new database to dev2owner.



Grateful if someone can give me some advice.



Many thanks.



Regards,


Timmy
Received on Wed Mar 19 2003 - 04:29:52 CST












Original text of this message













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