You can't rename user.

But you can

1) take the user level export of <userA>
$ exp file=test.dmp owner=userA
2) Create the user <user B>
SQL> create user ..............
3) import the user A export dump in to user B
$imp file=test.dmp fromuser=userA touser=userB
4) drop the user <user A>
SQL> drop user ............




Menaka wrote:
> Hai all,
> If it is possible to rename the user? possible means how?
>
> Thanks
> Menaka
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>

Oracle LazyDBA home page