Re: change oracle schema name

From: Pete Sharman <peter.sharman_at_oracle.com>
Date: 11 May 2002 07:53:10 -0700
Message-ID: <abjb8m02cht@drn.newsguy.com>

In article <ZP8D8.44793$US3.978644_at_twister1.libero.it>, "Mark" says...
>
>Is it a way, or a dirty trick to change the name of an oracle user schema,
>without
>dropping and creating its objects?
>
>regards
>Mark
>
>

No supported "dirty trick", but you can get what you want by doing an export and import with the fromuser and touser parameters, or alternatively leave the schema under the existing user name and create synonyms for the new user to point to the old user objects.

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Sat May 11 2002 - 09:53:10 CDT