ora-01935

[hummy]

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

[julian]

Could it be that you are using bind varibales with DBMS_SQL?
Bind variables can't be used as DB objects.

[Shestakov]

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 ...