Oracle创建表空间和表空间用户的步骤
1、建立数据库实例:orcl
2、建立表空间:BSCHIS
3、建立用户:zhwsj
4、给指定的用户zhwsj赋予权限(一般connect、dba)
--创建BSCHIS表空间
CREATE TABLESPACE ZHEHR DATAFILE 'E:\oracle\app\Administrator\oradata\oracle\ZHEHR' SIZE 100M AUTOEXTEND On Logging OnlinePermanent EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AutoBLOCKSIZE 8K ;
---创建BSCHIS表空间用户
create user thj identified by thj1122 default tablespace ZHEHR temporarytablespace TEMP profile DEFAULT;
grant connect to thj;
grant dba to thjJ;
grant unlimited tablespace to thj;
--查询已用表空间
SQL> select tablespace_name,status from dba_tablespaces;
SQL> select name from v$datafile;
删除表空间用户
drop user THJ cascade;