3 Replies Latest reply on Aug 30, 2018 1:51 AM by M.Dilipkumar

    Is that possible to change DATABASE_VALUE=CHAR ?

    M.Dilipkumar

      Anyone knows, how to change DATABASE_VALUE to CHAR? my database is running on 12cr2 version. it have mistakenly created to BYTE.

      I've manage to change NLS_LENGTH_SEMANTICS to CHAR by altering it.

      I know DATABASE_VALUE parameter is set when we create the database, but just curious to know is that possible to change it ? or do i need to drop database and recreate back with CHAR instead of BYTE.

      Or this is fine, can i ignore DATABASE_VALUE and proceed with this value?

       

      initial parameter:

      PARAMETER

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

      DATABASE_VALUE

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

      SESSION_VALUE

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

      INSTANCE_VALUE

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

      NLS_LENGTH_SEMANTICS

      BYTE

      BYTE

      BYTE

       

      After try: alter system set nls_length_semantics='CHAR' scope=both;

       

      PARAMETER

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

      DATABASE_VALUE

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

      SESSION_VALUE

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

      INSTANCE_VALUE

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

      NLS_LENGTH_SEMANTICS

      BYTE

      CHAR

      CHAR