Resetting system password in oracle
***********************************
If you have forgotten system password in oracle,you can do the following to reset it.
1> start->run-> type Sqlplus
2> Enter user-name: conn /as sysdba
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
3> SQL> alter user system identified by samsung;
User altered.
You have successfully changed the system password to samsung.
samsung is the new password.and you need not worry about previous password
***********************************
If you have forgotten system password in oracle,you can do the following to reset it.
1> start->run-> type Sqlplus
2> Enter user-name: conn /as sysdba
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
3> SQL> alter user system identified by samsung;
User altered.
You have successfully changed the system password to samsung.
samsung is the new password.and you need not worry about previous password
No comments:
Post a Comment