Thursday 23 May 2013

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…

No comments:

Post a Comment