[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

want to change user name

Posted on 2011-09-27
2
Medium Priority
?
276 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 16

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses
Course of the Month18 days, 10 hours left to enroll

834 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