About Me

My photo
Pune, Maharashtra, India
Working on Oracle technology for more than 14+ years.Oracle Certified professional. Expertise in Oracle advance technologies like Oracle Real Application Cluster (RAC) , Oracle DataGuard, Oracle ASM, Oracle Golden gate. Experience in Area of migration/Replication of Oracle Database. Expertise in Storage/OS administration,Vertulization, Cloud technology. Activly involed in forum discussion of RAC sig and DBA village.

Thursday, January 26, 2012

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 ........