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!

Need help in creating a Windows batch file to change passwords across all databases using substituti

User556071-OCJan 9 2017 — edited Jan 9 2017

Here is what I have done so far. The batch scripts looks good. But the sql script is worng. Please help

BATCH FILE - Attached

SQL FILE

============

alter user mysuer identified by &1;
exit

When I run the script like this,

E:\DBA\Scripts\chgpwd.bat scott password1 password2

It says the user 'Scott' does not exist.

I know I am doing something silly. Please help

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 6 2017

Added on Jan 9 2017

3 comments

733 views