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
>

export the user, drop the user, import the user with imp fromuser=dev1owner touser=dev2owner

or reconsider your naming scheme.

Schema's can't be renamed and synonyms are on object level. A schema isn't an object.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Mar 19 2003 - 05:09:50 CST