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;