//创建临时表空间
create temporary tablespace test_temp
tempfile 'F:\app\Administrator\oradata\orcl\test_temp.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
//创建数据表空间
create tablespace test_data
logging
datafile 'F:\app\Administrator\oradata\orcl\test_data.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
//创建用户并指定表空间
create user gzjyxt identified by gzjyxt;
default tablespace test_data
temporary tablespace test_temp;
//给用户授予权限
grant dba to gzjyxt;
本内容试读结束,登录后可阅读更多
下载后可阅读完整内容,剩余1页未读,立即下载