The create user c # # mldnuser
2 identified by java_android
3 the default in tablespace mldn_data
4 temporary in tablespace mldn_temp
5 30 m quota on mldn_data
6 20 m quota on the users
7 the account unlock
8 the password expire;
The create user c # # mldnuser

Line 1 error:
ORA - 00959: a table space 'MLDN_DATA' does not exist

CodePudding user response:

3 default in tablespace mldn_data



Between the table does not exist, you can create, he can also change the default in tablespace USERS

CodePudding user response:

Not create table space, you see your common user with which table space,
Select the username, default_tablespace from dba_users where username='user name';

When created with the same table space

CodePudding user response:

Your table space into the default USER

CodePudding user response:

 
The create user mldnuser identified by java_android 
The default in tablespace users 
Temporary in tablespace temp 
Quota 50 m on the users; 

Change the default space, and then established the size of all the users to the default space