Home > IT Answers > Oracle > Rename the Oracle 10g database user
S19890820
50 pts.
 Rename the Oracle 10g database user
Oracle 10g, Oracle 10g Database, Oracle Database
Hi. I want to rename the database user(username)without deleting the user and again creating in ORACLE 10g database??? plz, help me

Software/Hardware used:
ORACLE 10g
ASKED: January 13, 2011  2:23 PM
UPDATED: August 12, 2011  12:54 PM
RELATED QUESTIONS
Answer Wiki:
AFAIK, you can't. If you are on a 10g database, you should consider using Datapump. Datapump has a feature to clone database users (REMAP_SCHEMA), Loads all objects from the source schema into a target schema, and datapump has some interesting performance parameters. There is no way to rename a user. You will need to do an export-import.
Last Wiki Answer Submitted:  August 12, 2011  12:54 pm  by  carlosdl   63,535 pts.
All Answer Wiki Contributors:  carlosdl   63,535 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

I have just realized that you asked this same question last year. Do you have something else to add ?

carlosdl
 63,535 pts.