Saturday, February 6, 2010

How to unlock Sample HR database in oracle

How to unlock Sample HR database in oracle
For working with tutorial of oracle Introduaction to oracle/sql you need to work on the tables which is locked in oracle. for Unlocking these tables you have to follow these steps

1. Login in sqlplus or sqlplus or isqlplus as a user “system” with respective password.

2. Execute the following command

ALTER USER HR IDENTIFIED BY password ACCOUNT UNLOCK;

here password is your passord which you want to use for your account remember this password for further use.

3. Login in with user HR with password specified above

Now you can use all tables specified in tutorial.

Please leave your comment If you encounter any problem…