ora-01935
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ora-01935

  1. #1
    Join Date
    Apr 2001
    Posts
    55
    when i create an oracle user with numbers i get the following error

    ORA-01935: missing user or role name

    The user i am trying to create is called 11691 and i get the above error.

    Any ideas how i could resolve this.

    Thankyou

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Could it be that you are using bind varibales with DBMS_SQL?
    Bind variables can't be used as DB objects.



  3. #3
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    This is problem in name of user, because:
    -----------------------------------------------------------
    A name must begin with an alphabetic character from your database character set unless surrounded by double quotation marks.
    AND USERNAME TOO.
    -----------------------------------------------------------
    name of your user - 11691
    -----------------------------------------------------------
    How your can resolve this problem:

    1. Check, is this problem exists:
    - connect as SYS user
    - select * from user$ where name='11691';
    if no rows found, then problem exists.
    if you get 1 row then we should solve it.
    (little bit later)

    2. Solve ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width