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
Printable View
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
Could it be that you are using bind varibales with DBMS_SQL?
Bind variables can't be used as DB objects.
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 ...