--创建表空间
create tablespace NNC_DATA01 datafile
'C:\SoftWare\Oracle\Oracle12c\oradata\orcl\NC6\nnc_data01.dbf' size
500M autoextend on next 50M extent management local uniform
size 512k;
create tablespace NNC_INDEX01 datafile
'C:\SoftWare\Oracle\Oracle12c\oradata\orcl\NC6\nnc_index01.dbf' size
500M autoextend on next 50M extent management local uniform
size 256k;
-- 创建用户
Create user ncdev identified by ncdev default tablespace
NNC_DATA01 temporary tablespace temp;
Grant connect,dba to ncdev;