Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Posts
    45

    Unanswered: User name in oracle

    Is it possible to change the user name in oracle.If so ,how??

    Regards

  2. #2
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    follow the procedure below.

    (1) perform export in the USER mode with the username you want to change.

    (2) Create the new user You want to change to.

    (3) Perforf import with the two option FROMUSER=<old user name>
    TOUSER=<Newly Creted User>
    (4) check that New user has all the objects as Previous User has.

    (5) Drop the Previous (Old User).

    In Oracle, there is not any ALTER USER or something like that statement that you can change the user's name.

    HTH
    Bhavin

    MS Computer Science
    OCP DBA 9i/8i

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •