oracle创建用户及表空间

oracle创建用户及表空间

---创建临时表空间
create temporary tablespace PMS_TEMP
TEMPFILE 'C:\app\49992\oradata\orcl\PMS_TEMP_DATA.DBF'
size 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL;
-----创建 正式表空间
create tablespace PMS
logging
DATAFILE 'C:\app\49992\oradata\orcl\PMS_DATA.DBF'
size 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL;

-----创建用户
create user PMS
identified by PMS
account unlock
default tablespace PMS
temporary tablespace PMS_TEMP
profile DEFAULT;
------赋予权限
grant dba to PMS;--连接数据库权限