Oracle Database Discussions

Hi Team,

I am a junior DBA. As a Part of my work logged in as a SYSDBA and try to drop/Alter the user, then it given below errors.

By using select command, i found user is existed.

Please suggest and help to me.

SQL > show user

USER is "SYS"

SQL > select username,account_status from dba_users where username='s354621';

USERNAME              ACCOUNT_STATUS

------------------------------ --------------------------------

s354621                        EXPIRED

SQL > DROP USER s354621

  2  /

DROP USER s354621

          *

ERROR at line 1:

ORA-01918: user 'S354621' does not exist

=========================================

SQL > Alter user s354621 identified by "happy33";

Alter user s354621 identified by "happy33"

           *

ERROR at line 1:

ORA-01918: user 'S354621' does not exist

============================================

Thanks,

Ven..