want to change user name

Hi,
Is it possible to change user name in 11g without dropping it.
nirvairghumanAsked:
Who is Participating?
 
sdstuberCommented:
no, sorry


you can export the user and objects with expdp  or exp  and then drop the user and import  (impdp/imp)


0
 
Swadhin RaySenior Technical Engineer Commented:
Changing user name in oracle is not possible but as sdstuber said you can do like :

1) create a new user :

create user new identified by <<new password>>

2) Export the old user data to .dmp file :
exp system/password owner=<<Old user name >> file=userold.dmp log=userold.log

3) import the .dmp file to the new user :
imp system/password fromuser=<<Old user name >> touser=new file=userold.dmp log=Import.log

You can also do this by using datapump .
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.