Improve company productivity with a Business Account.Sign Up

x
?
Solved

want to change user name

Posted on 2011-09-27
2
Medium Priority
?
278 Views
Last Modified: 2012-05-12
Hi,
Is it possible to change user name in 11g without dropping it.
0
Comment
Question by:nirvairghuman
2 Comments
 
LVL 74

Accepted Solution

by:
sdstuber earned 252 total points
ID: 36710844
no, sorry


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


0
 
LVL 17

Assisted Solution

by:Swadhin Ray
Swadhin Ray earned 248 total points
ID: 36714624
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

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

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.

Join & Write a Comment

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that useā€¦
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.

595 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question