--创建临时表空间
create temporary tablespace blood_temp
tempfile 'D:\oracle\product\10.2.0\oradata\orcl\blood_temp.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
--创建数据表空间
create tablespace blood
logging
datafile 'D:\oracle\product\10.2.0\oradata\orcl\blood.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
--创建用户并指定表空间
create user blood identified by HaierPassw0rd
default tablespace blood
temporary tablespace blood_temp;
--给用户授予权限
grant connect,resource,dba to blood;
---去掉表空间限额
alter user blood quota unlimited on blood;
create temporary tablespace blood_temp
tempfile 'D:\oracle\product\10.2.0\oradata\orcl\blood_temp.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
--创建数据表空间
create tablespace blood
logging
datafile 'D:\oracle\product\10.2.0\oradata\orcl\blood.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
--创建用户并指定表空间
create user blood identified by HaierPassw0rd
default tablespace blood
temporary tablespace blood_temp;
--给用户授予权限
grant connect,resource,dba to blood;
---去掉表空间限额
alter user blood quota unlimited on blood;