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;