How to DISABLE CASE SENTIVITIY of SCHEMA Logins in ORACLE

* Check the current status of the CASE Sensitive parameter.

1) Log in to database as SYS or SYSTEM

C:\sqlplus system/password@PIONEERS


SQL> show parameter case;

Output will be like below.

NAME                                 TYPE        VALUE
------------------------------------ ----------- ---------
sec_case_sensitive_logon             boolean     TRUE


* Alter the value and disable the CASE sensitivity.

SQL> alter system set sec_case_sensitive_logon=FALSE;

"System altered." message will be appear.

*  Check the new status of the CASE Sensitive parameter as mentioned in the first step.

SQL> show parameter case;

NAME                                 TYPE        VALUE
------------------------------------ ----------- -------------
sec_case_sensitive_logon             boolean     FALSE