1.用Oracle用户登录sqlplus
sqlplus / as dba
2.创建临时表空间 miya_temp
我的Oracle安装路径是/data/oracle/product/11.2.0/db_1/
在这个目录下mkdir database
create temporary tablespace miya_temp
tempfile '/data/oracle/product/11.2.0/db_1/database/miya_temp.dbf'
size 10m
autoextend on
next 10m maxsize 20480m
extent management local;
3.创建数据表空间 miya
create tablespace miya
loggingdatafile '/data/oracle/product/11.2.0/db_1/database/miya.dbf'
size 10m
autoextend on
next 10m maxsize 20480m
extent management local;
4.创建用户并指定表空间 miya是用户名,miya123是密码
create user miya identified by miya123
default tablespace miya
temporary tablespace miya_temp;
5.给用户授权
grant connect,resource,dba to miya;
附加内容
给用户无限表空间权限
grant unlimited tablespace to miya;
删除表空间
drop tablespace miya;
删除用户
drop user miya;