I am new to Oracle and I am trying to create a simple table as USER1. I connect as SYS and create USER1, USER2 as follow:
CREATE USER "USER1" IDENTIFIED BY "user1pass"
DEFAULT TABLESPACE "users"
TEMPORARY TABLESPACE "TEMP"
GRANT "CONNECT" TO "USER1";
GRANT CREATE TABLE TO "USER1";
When I connect as USER1 and create a simple table "mytable" using TABLESPACE users I got this error:
ORA-00959: tablespace 'USERS' does not exist
but the tablespace 'USERS' is there.
What do I need to do to fix it?