Let say i have a password name T@mp
I want to change it to Hello
but if i use this following query with my user it wont compile as my old password contain @-signs
alter user MYUSER identified by Hello replace T@mp
I am using TOAD
I am changing my password to normal character because, @-signs also creating problem in SQL loader
sqlldr myuser/T@mp@prodcms control=loading.ctl
As @Wernfried Domscheit has shown, you have to enclose the old password in double quotes as shown below.