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
Export DataPump and Import DataPump FAQ (Doc ID 556636.1)Export DataPump and Import DataPump FAQ (Doc ID 556636.1)
1.Purpose This Frequently Asked Questions (FAQ) provide […]
Oracle home preferred locations for 19cOracle home preferred locations for 19c
I have used for GRID_HOME and DB_HOME the following loc […]
hint to enforce FULL SCAN with direct path readhint to enforce FULL SCAN with direct path read
from https://community.oracle.com/tech/apps-infra/discu […]