database - Oracle DBMS 12c, How to create a user that can create tables -


i installed oracle 12c on system, intending develop few simple tables. how create user can create , manipulate tables? right way can access dbms sqlplus "/as sysdba".

i created tablespace. when try create user tablespace it's default, tells me tablespace not exist. run "select * v$tablespace" , see tablespace.

i feel i'm missing fundamental here. i've been reading on oracle's documentation, nothing seems work. specifically, user creation. examples oracle has cause me errors, complains pluggable databases. after reading, pluggable databases new feature of 12c, have append c## front user names. think makes 'common' user, although i'm not sure is. regardless, using "c##test" can't find tablespace. :-(

sql> create tablespace dbclassspace;  sql> create user c##test   2  identified secret   3  default tablespace dbclassspace   4  quota 10m on dbclassspace   5  temporary tablespace temp; create user c##test * error @ line 1: ora-65048: error encountered when processing current ddl statement in pluggable database plugdbclass ora-00959: tablespace 'dbclassspace' not exist  sql> select user dual;  user ------------------------------ sys  sql> select * v$tablespace;         ts# name                           inc big fla enc     con_id ---------- ------------------------------ --- --- --- --- ----------          1 sysaux                         yes no  yes              1          0 system                         yes no  yes              1          2 undotbs1                       yes no  yes              1          4 users                          yes no  yes              1          3 temp                           no  no  yes              1          0 system                         yes no  yes              2          1 sysaux                         yes no  yes              2          2 temp                           no  no  yes              2          0 system                         yes no  yes              3          1 sysaux                         yes no  yes              3          2 temp                           no  no  yes              3         ts# name                           inc big fla enc     con_id ---------- ------------------------------ --- --- --- --- ----------          3 users                          yes no  yes              3          5 dbclassspace                   yes no  yes              1 

...

sql> select tablespace_name cdb_tablespaces;      tablespace_name     ------------------------------     system     sysaux     undotbs1     temp     users     dbclassspace     system     sysaux     temp     users      10 rows selected.      sql> create user c##test       2  identified secret       3  default tablespace dbclassspace       4  quota 10m on dbclassspace       5  temporary tablespace temp;     create user c##test     *     error @ line 1:     ora-65048: error encountered when processing current ddl statement in     pluggable database plugdbclass     ora-00959: tablespace 'dbclassspace' not exist 

you need assign volume in tablespace user create table. if in cdb$root:

create user c##u1          identified password          default tablespace sysaux          quota 10m on sysaux          temporary tablespace temp;