5 Replies Latest reply on Aug 4, 2014 3:33 PM by Bruno.Vroman

    Database username contains a space character


      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