Rename the Oracle 10g database user

S19890820
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: Last updated:
Related Questions

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: 2  Replies

 
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.
  • carlosdl
    I have just realized that you asked this same question last year. Do you have something else to add ?
    84,495 pointsBadges:
    report
  • mizanmas
    How can I rename database user?
    25 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.

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

Following

Share this item with your network: