Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Rename a user

KSGOct 12 2011 — edited Oct 17 2011

Hi,

Oracle 11gR2 on linux

How to rename a user?

like there is a user exist in the database called userA, now I've to just rename it to userB.

I dont want to perform exp/imp or expdp of the schemas. I understand there is no possibility to directly rename the user in previous oracle releases.

I know there is option in SQLServer like "alter user abc with name='abc123'; this way we can rename the user. Is there any similar commands available for Oracle.

Thanks
KSG

This post has been answered by Girish Sharma on Oct 16 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 14 2011

Added on Oct 12 2011

#general-database-discussions

26 comments

14,037 views