–创建两个数据库的文件（monitor.dbf 和monitor_temp.dbf 两个文件）
CREATE TABLESPACE monitor LOGGING DATAFILE \’C:\install\DB\oracle\app\oracle\oradata\xe\monitor.dbf\’
SIZE 100M AUTOEXTEND ON NEXT 32M MAXSIZE 1000M EXTENT MANAGEMENT LOCAL;

create temporary tablespace monitor_temp tempfile \’C:\install\DB\oracle\app\oracle\oradata\xe\monitor_temp.dbf\’
size 100m autoextend on next 32m maxsize 1000M extent management local;

–创建用户与上面创建的文件形成映射关系（用户名为monitor,密码为monitor）
CREATE USER monitor IDENTIFIED BY monitor DEFAULT TABLESPACE monitor TEMPORARY TABLESPACE monitor_temp;

–添加权限
grant connect,resource,dba to monitor;
grant create session to monitor;

–创建两个数据库的文件（TS_KA_DATA.dbf 和TS_KA_DATA_temp.dbf 两个文件）
CREATE TABLESPACE TS_KA_DATA LOGGING DATAFILE \’C:\install\DB\oracle\app\oracle\oradata\xe\TS_KA_DATA.dbf\’
SIZE 100M AUTOEXTEND ON NEXT 32M MAXSIZE 1000M EXTENT MANAGEMENT LOCAL;

create temporary tablespace TS_KA_DATA_temp tempfile \’C:\install\DB\oracle\app\oracle\oradata\xe\TS_KA_DATA_temp.dbf\’
size 100m autoextend on next 32m maxsize 1000M extent management local;

–创建用户与上面创建的文件形成映射关系（用户名为generalDB,密码为generalDB）
CREATE USER generalDB IDENTIFIED BY generalDB DEFAULT TABLESPACE TS_KA_DATA TEMPORARY TABLESPACE TS_KA_DATA_temp;

–添加权限
grant connect,resource,dba to generalDB;
grant create session to generalDB;

版权声明：本文为xiaohaizhuimeng原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://www.cnblogs.com/xiaohaizhuimeng/p/10969079.html