| how to create user defined users(like scott,system) [message #72834] |
Wed, 12 November 2003 06:03  |
upendar
Messages: 1
Registered: November 2003
|
Junior Member |
|
|
dear friends i tried following code for creating users in oracle 8i, but iam not able to create.
see my code and give your valuable suggestions:
create user <user name> identified by <password>
default tablespace user
temporary tablespace temp
quota 1M on user
quota unlimited on temp
profile default;
if i typed like that iam getting following error
ORA-02155: invalid DEFAULT tablespace identifier
|
|
|
|
| Re: how to create user defined users(like scott,system) [message #72835 is a reply to message #72834] |
Wed, 12 November 2003 12:20  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
User is a reserved word and hence an invalid identifier for the default tablespace. Did Oracle let you create a tablespace named user , in the first place ?
SQL> create tablespace user datafile '/r5v1/oracle1/oradata/DEV09/user_test.dbf' size 5m;
create tablespace user datafile '/r5v1/oracle1/oradata/DEV09/user_test.dbf' size 5m
*
ERROR at line 1:
ORA-02216: tablespace name expected
Create a tablespace named USERS and assign that as the default tablespace instead or maybe it was just a typo(ie change user to users).
-Thiru
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
