Re: How to rename a schema

On Wed, 19 Mar 2003 18:29:52 +0800, "Timmy Sin" <tswsin_at_yahoo.com> wrote:

>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
>

My first question is "'why?" Why do you want to change the name of the schema owner in a cloned db? There may very well be good reasons, but I get the impression from what you've said so far that it is simply because it is in another db. Not a good reason. In fact, if I've got a 'cloned' database (like a test copy of production) I *don't* want things renamed from one DB to the other. You are making extra work for yourself now, and possibly a lot of extra work down the road. Received on Wed Mar 19 2003 - 08:04:33 CST