we are doing a refresh of Dev database from Prod. Oracle version is 19.24
Previously in 11g and 12c we had a way of backing up the existing schema password in encrypted form and restore it back. But in 19c this is not working
Do we have any other methods or doing this in 19c ?
in 12c we used to do this
SQL> SELECT spare4 FROM sys.user$ WHERE name = 'SCOT';
SQL> alter user test identified by values ‘ <PWD Frome above step>’;