steps to reset original password

Use below steps to reset original password:

Look at the example:

schema name is : OASTOLTP

SQL> set lines 9999
set pages 9999
set long 90000000SQL> SQL>
SQL>
SQL> select dbms_metadata.get_ddl('USER','OASTOLTP') from dual;

DBMS_METADATA.GET_DDL('USER','OASTOLTP')
--------------------------------------------------------------------------------

CREATE USER "OASTOLTP" IDENTIFIED BY VALUES 'S:46DE8181197D5D6A2BEE2B43B21762
BE9B725B07217DA76100F37D12598D;6B9A3DF7BDFDD198'
DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP_0"


SQL>

to reset original password you will user above command as

ALTER USER OASTOLTP IDENTIFIED BY 'you will get encrypted password of OASTOLTP' default tablespace ........