Oracle changing password, where old password contain @-signs

3.7k views Asked by At

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

enter image description here

I am changing my password to normal character because, @-signs also creating problem in SQL loader

sqlldr myuser/T@mp@prodcms control=loading.ctl
1

There are 1 answers

0
atokpas On BEST ANSWER

As @Wernfried Domscheit has shown, you have to enclose the old password in double quotes as shown below.

SQL> alter user sales_hr identified by password replace p@assword;
alter user sales_hr identified by password replace p@assword
                                                        *
ERROR at line 1:
ORA-00922: missing or invalid option


SQL> alter user sales_hr identified by password replace "p@ssword";

User altered.