If you are a newbie to Oracle XE, this article will be definite help. Whenever xe is installed it comes default with HR schema however the shcema/user will be in locked/expired state. So to continue to create connection to hr account we first need to unlock the HR schema/user.
To unlock the HR Schema that will be used in the lab, please follow these steps.
Your database should have the HR schema enabled.
To do this, from a command line issue the command: sqlplus system
Provide the password for the system user.
In the SQLPLUS prompt write the following command Alter user HR account unlock ;
Alter user HR identified by HR;
To unlock the HR Schema that will be used in the lab, please follow these steps.
Your database should have the HR schema enabled.
To do this, from a command line issue the command: sqlplus system
Provide the password for the system user.
In the SQLPLUS prompt write the following command Alter user HR account unlock ;
Alter user HR identified by HR;
