创建表空间、用户、授权、扩展表空间

创建表空间、用户、授权、扩展表空间
CREATE TABLESPACE NNC_DATA02 DATAFILE ‘F:\ORADATA\nnc_data02.dbf’ SIZE 500M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ;
CREATE TABLESPACE NNC_INDEX02 DATAFILE ‘F:\ORADATA\nnc_index02.dbf’ SIZE 500M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K ;
create user nc identified by “1” default tablespace NNC_DATA02 ;
grant connect,dba to nc;
CREATE DIRECTORY nc AS 'F:\ ';
grant read,write on directory nc to nc;
alter tablespace NNC_DATA01 add datafile ‘G:\nnc_data012.DBF’ size 500M autoextend on maxsize 30720M;