Oracle database comes with a built in sample schema/user containing the familiar EMP-DEPT tables which can be used for practice.
Previously this used to be under the user/schema SCOTT.
But in the recent releases this has been replaced with the user/schema HR.
To use the HR schema you need to unlock it and reset the password first.
Log in to the database as sys using sqlplus and run the following command to unlock the HR schema.
ALTER USER HR IDENTIFIED BY welcome1 account unlock;
HR schema is now unlocked and its password is set to welcome1.
Previously this used to be under the user/schema SCOTT.
But in the recent releases this has been replaced with the user/schema HR.
To use the HR schema you need to unlock it and reset the password first.
ALTER USER HR IDENTIFIED BY welcome1 account unlock;
HR schema is now unlocked and its password is set to welcome1.
Post a Comment