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
DataGuard not sync troubleshootingDataGuard not sync troubleshooting
1)Check RECOVERY_FILE_DEST col name for a15 SELECT name […]
Oracle Compile Invalid objectsOracle Compile Invalid objects
1) find invalid objects select owner,object_name,object […]
《收获，不止SQL优化》 – 调优信息一键生成脚本《收获，不止SQL优化》 – 调优信息一键生成脚本
转：https://cloud.tencent.com/developer/article/1415749 梁 […]