I have installed Oracle 11g R2 on my Windows. During the installation, in password management, the "scott" user is missing. I'm unable to login in "scott" as my sample schema.
What do I have to do in order to get the "scott" user in my database?
It may already be there (if you installed the demo schema) but locked for security reasons.
Log in as SYSTEM or SYS.
SQL > alter user scott account unlock;
I think you have not unlocked your
When you started installing oracle ,it asked for
Error message is displayed: the account is locked.
Now you can type