Sql – How to activate the hr schema in Oracle 11g

oracleoracle-sqldeveloperoracle11gsql

I am learning PL/SQL and am using SQL Developer cause I created many users with hr schema. But when a user logs in to SQL Developer give an error like the users is invalid. but When I use the system user, it works perfectly but without hr schema.

So:

  • How can I activate the hr schema in system user or
  • How can I make a user for use in SQL developer.

I am using Oracle 11g express

Best Solution

ALTER USER hr IDENTIFIED BY hr ACCOUNT UNLOCK;

Then, enter this command

CONNECT HR/HR