oracle 表空间创建

数据库：testwyi
密码： testwyi

在CMD中进行操作

sqlplus sys/密码 as sysdba

--创建表空间

create tablespace testwyi
datafile 'd:/oracle_testwyi/data/testwyi.dbf'
size 50m
autoextend on
next 50m maxsize unlimited
extent management local;

---- 创建临时表空间

create temporary tablespace testwyi_temp
tempfile 'D:\oracle_testwyi\data\testwyi_temp.dbf'
size 50m
autoextend on
next 50m maxsize unlimited
extent management local;

-------------------------------------------------------------------------------------------------------------------------------------------

通常在create 用户时，就要指定其默认表空间create user username identified by password default tablesapce tablespacename

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

----创建用户

create user wyi
  identified by wyi
  default tablespace testwyi
  temporary tablespace testwyi_temp;

----分配权限

grant connect to wyi;

grant dba to wyi;

---------------------------------
账户锁定：
alter user wyi account unlock;
---------------------------------