#308
[Oracle] Create new user/schema
Create simple tablespace :
create tablespace <tablespace_name> datafile '<tablespace_file>' size 256M autoextend off segment space management auto;
Create user/schema :
create user <user_name> identified by <user_password> default tablespace <tablespace_name> temporary tablespace <temp_tablespace_name> quota unlimited on <tablespace_name> quota unlimited on <tablespace_name_1> quota unlimited on <tablespace_name_2>;
Change grants :
grant ALTER ANY SEQUENCE,CONNECT,CREATE SESSION,RESOURCE to <user_name>;
[NAS] Install Synology DSM [Mint] Installing RabbitVCS with Nemo
ERROR at line 1:
ORA-65096: invalid common user or role name
as sysdba :
http://www.dba-oracle.com/t_ora_65096_create_user_12c_without_c_prefix.htm