/*第1步:创建临时表空间 */
create temporary tablespace PPP_TEMP
tempfile 'D:\app\dell\oracledata\ppporcl\PPP_TEMP.dbf'
size 5G
autoextend on
next 200m maxsize unlimited
extent management local;
---创建表空间---
create tablespace PPP_DATA
logging
datafile 'D:\app\dell\oracledata\ppporcl\PPP_DATA.DBF'
size 5G
autoextend on
next 200m maxsize unlimited
extent management local;
---创建用户----
create user EFMIS_CMS identified BY 1 default tablespace PPP_DATA temporary tablespace PPP_TEMP;
---给用户授权---
grant connect,resource,dba to EFMIS_CMS;
oracle创建表空间和用户
最新推荐文章于 2018-11-18 19:25:00 发布