Hi Folks,
Can you please let me know how come Malladi got the output with duplicate names in similar case letters?? B'coz, as Stecal said, The duplicate name should be of different case letters, but malladi has got the output of having the duplicates also in the same case as if the original ones.

SQL> create user raju identified by raju;

User created.

SQL> grant connect to raju;

Grant succeeded.

SQL> select username from dba_users;

USERNAME
------------------------------
SYS
SYSTEM
OUTLN
DBSNMP
TRACESVR
ESTORE
OAS_PUBLIC
CMS2ADM
WTADMIN
SPOTLIGHT
WVAHOSP

USERNAME
------------------------------
RTSDEMO
IMAGE
ABC
REP
RAJU

16 rows selected.

SQL> create user "raju" identified by "raju"
2 /

User created.

SQL> grant connect to "raju";

Grant succeeded.

SQL> select username from dba_users;

USERNAME
------------------------------
SYS
SYSTEM
OUTLN
DBSNMP
TRACESVR
ESTORE
OAS_PUBLIC
CMS2ADM
WTADMIN
SPOTLIGHT
WVAHOSP

USERNAME
------------------------------
RTSDEMO
IMAGE
ABC
REP
RAJU
raju

17 rows selected.

SQL> conn raju/raju@hpdevl;
Connected.

SQL> conn system/manager@hpdevl;
Connected.
SQL> drop user "raju";

User dropped.

SQL> create user "RAJU" identified by raju;
create user "RAJU" identified by raju
*
ERROR at line 1:
ORA-01920: user name 'RAJU' conflicts with another user or role name


SQL> create user "raju" identified by raju;

User created.

SQL> select username from dba_users;

USERNAME
------------------------------
SYS
SYSTEM
OUTLN
DBSNMP
TRACESVR
ESTORE
OAS_PUBLIC
CMS2ADM
WTADMIN
SPOTLIGHT
WVAHOSP

USERNAME
------------------------------
RTSDEMO
IMAGE
ABC
REP
RAJU
raju

17 rows selected.


Here it's not accepting me to create with the same case letters as "RAJU" where as its accepting a duplicate as "raju". Then how did he get the duplicate usernames also in the same case???

Can any one explain me?

Thanks in advance