I know this question has been asked many times, but this problem is confusing me a lot. I just installed Oracle 11g R2. And I was trying to unlock Scott/Tiger account so that I can use them to make a SQL Developer connection. I was trying to do something like below- And I always get user SCOTT does not exist? Why is it so? Is there anything wrong I am doing?
SQL> conn system/abcdef1234
Connected.
SQL> alter user scott account unlock;
alter user scott account unlock
*
ERROR at line 1:
ORA-01918: user 'SCOTT' does not exist
Any thoughts will be appreciated.
Updates:-
SQL> select username,account_status from dba_users where username='SCOTT';
no rows selected