oracle11g创建用户和赋权限

1.查找当前表空间数

SELECT COUNT(*) FROM DBA_DATA_FILES; 

SELECT FILE_NAME,TABLESPACE_NAME,BYTES,USER_BLOCKS FROM DBA_DATA_FILES;
SELECT TABLESPACE_NAME FROM DBA_DATA_FILES;

2.创建表空间
create tablespace NNC_DATA01 datafile 'D:\Oracle\oradata\sinosoft\nnc_data01.dbf' size 500M autoextend on next 50M extent management local uniform size 512k; 
create tablespace NNC_INDEX01 datafile 'D:\Oracle\oradata\sinosoft\nnc_index01.dbf' size 500M autoextend on next 50M extent management local uniform size 256k;

3.创建用户并赋权限
Create user nc631 identified by a default tablespace NNC_DATA01 temporary tablespace temp; 
Grant connect,dba to nc631;

4.删除用户

drop user nc631 cascade;