5 Replies Latest reply: Aug 4, 2014 10:33 AM by brunovroman RSS

    Database username contains a space character

    DeshmukhP

      Hi I recently found that i have a Oracle username contains a space character at the end.

      by using update statement i have corrected the username ( now username with no space at the ) but still I am not able to connect with modified username(without space), however when I put space at the end I can connect to oracle.

       

      I have confirmed that I need to make update with two tables only and corrected both but unable to login with corrected username.

       

      for example 'prajakta.deshmukh@oracle.co.uk' and 'prajakta.deshmukh@oracle.co.uk ' ,  i am able to connect to the user with space char. Please advice how it can be done.

       

      Thank you

       

      Prajakta