Re: Can one rename a database user (schema) with oracle9i ?

From: Harald Maier <maierh_at_myself.com>
Date: Fri, 22 Aug 2003 11:44:30 +0200
Message-ID: <m3y8xmf2m9.fsf@ate.maierh>

"Tanel Poder" <change_to_my_first_name_at_integrid.info> writes:

> No, there's no supported way of doing it with a simple command.
> Drop & recreate instead. If you got data under the user, then
> export; drop; recreate; import.

The 'imp' program provides here for the 'fromuser' and 'touser' option.

Harald

> "Luigi" <LuiginospamMarzella_at_libero.it> wrote in message
> news:ckj1b.257267$lK4.7950619_at_twister1.libero.it...
>> Dear all,

>> as stated on the subject I'd like to know if with Oracle 9i there's >> a built-in command to rename a user schema. Received on Fri Aug 22 2003 - 04:44:30 CDT