ORA-10615: Invalid tablespace type for temporary tablespace
Cause: Tablespace with AUTO SEGMENT SPACE MANAGENEMT specified cannot be used as a temporary tablespace
Action: Recheck the tablespace name and re-issue the statement
你在Sqlplus下面创建吧:
create user User1 identified by Password default tablespace datausr
temporary tablespace temp;
grant connect,resource,create table to User1;