-- 创建表空间
create tablespace wushan
logging
datafile 'F:\Oracle\oradata\orcl\wushan.ora'
size 256m
autoextend on
next 128m maxsize UNLIMITED
extent management local;
-- 创建临时表空间
create temporary tablespace wushan_temp
tempfile 'F:\Oracle\oradata\orcl\wushan_temp.ora'
size 64m
autoextend on
next 128m maxsize UNLIMITED
extent management local;
-- 创建用户
create user wushan
identified by wushan
default tablespace wushan
temporary tablespace wushan_temp
profile default;
-- 给予dba权限
grant dba to wushan with admin option;
