select
'alter user "'||username||'" identified by values '''||extract(xmltype(dbms_metadata.get_xml('USER',username)),'//USER_T/PASSWORD/text()').getStringVal()||''';' old_password
from dba_users
where username='PEACOCK';
Save user password
Categories:
Related Post
Oracle GoldenGate: Handle Collision Parameter and its usageOracle GoldenGate: Handle Collision Parameter and its usage
July 29, 2018 by Atul Kumar from: https://k21academy.co […]
Steps to Create and Transfer Profile from One Database to AnotherSteps to Create and Transfer Profile from One Database to Another
1. Create SQL Profile in SCOTT schema The SQL Profile i […]