Rename the Oracle 10g database user

60 pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    I have just realized that you asked this same question last year. Do you have something else to add ?
    65,110 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following