How to Unlock HR Schema in Oracle Database XE 11gR2 by using PL/SQL Developer

Oracle provides sample HR schema in all versions of its databases which is locked by default. For working with tutorial of Introduction to Oracle you need to work on HR schema. Follow the given below steps to unlock HR schema in Oracle Database XE 11gR2 by using PL/SQL Developer.

Login in PL/SQL Developer as a user “system or sysdba” with respective password

Click on New button and open Command Window


Execute the following command

ALTER USER HR IDENTIFIED BY password ACCOUNT UNLOCK;

Here password is your choise password which you want to use for HR schema.



Login in with user HR with password specified above. Now you can use all tables of HR schema by using PL/SQL Developer.

Comments

  1. postingan yang bagus tentang How to Unlock HR Schema in Oracle Database XE 11gR2 by using PL/SQL Developer

    ReplyDelete
  2. Very nice! I am looking for this type of info and sometimes I get lucky like today...:-). Thanks for your post.

    ReplyDelete
  3. Easy to read, interesting and easy to understand. What more do you want from a topic-specific article? Thanks for sharing!

    ReplyDelete
  4. Thank you so much!!

    ReplyDelete

Post a Comment

Popular posts from this blog

How to create Oracle stored Procedures using TOAD for Oracle

Create Tables in Oracle Database using TOAD

How to Create Packages in Oracle Database using TOAD for Oracle