I want to reset the SYS account in Oracle12c.
We are not allowed to do so using alter user syntax and we have to go with SQL> password sys as password should not be visible when you type.
We dont want to have dependency of carrying the old password. Is there anyway we can change the password without the prompt of old password like in previous version.
SQL> password sys
Changing password for sys
Old password:
New password:
Please suggest.