SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

alter user password with first character as numeric

Siva OraMar 18 2013 — edited Mar 20 2013

SQL> alter user user01 identified by 1arkspur
                                        *
ERROR at line 1:
ORA-00922: missing or invalid option

Then I tried with double quotes;

alter user sim01 identified by "1arkspur"

The issue is password first character is numeric one "1".

Question:
------------------------------------------------------------------------------------------------------------------------------------------------------

How to use the double quotes on the SQL Script file for the password? The issue is password first character is numeric one "1".

Example

sqlplus -s << _proc 2>&1
   sys/password@TestDB as sysdba
   set lines 200
   set pages 60

   spool pwd_change.lst

   set heading off
   select 'Oracle Server and Curr Date: '|| instance_name||' '||'${CNTY_CD}'||' '
      ||to_char(sysdate, 'yyyymmdd_HH24MISS')||'.' from v\$instance;

NW_USER01_PASSWD='1arkspur'
NW_USER02_PASSWD='1arkspur'

   *alter user user01 identified by ${NW_USER01_PASSWD};*
   *alter user user02 identified by ${NW_USER02_PASSWD};*

spool off;
   exit

Edited by: Sivaprasad S on Mar 18, 2013 5:08 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 17 2013

Added on Mar 18 2013

#user

8 comments

5,909 views