3.1.6. 创建表空间
Create tablespace maxdata datafile ‘D:\Oracle\oradata\maximo\maxdata.dbf’ size 1000M autoextend on; Create tablespace maxindex datafile ‘D:\Oracle\oradata\maximo\maxindex.dbf’ size 1000M autoextend on; create temporary tablespace maxtemp tempfile ‘D:\Oracle\oradata\maximo\maxtemp.dbf’ size 500M autoextend on maxsize unlimited; |
3.1.7. 创建用户授权
create user maximo identified by maximo default tablespace maxdata temporary tablespace maxtemp; alter user maximo quota unlimited on maxindex; grant connect to maximo; grant create job to maximo; grant create trigger to maximo; grant create session to maximo; grant create sequence to maximo; grant create synonym to maximo; grant create table to maximo; grant create view to maximo; grant create procedure to maximo; grant alter session to maximo; grant execute on ctxsys.ctx_ddl to maximo; alter user maximo quota unlimited on maxdata;
–grant create user to MAXIMO; –grant drop user to MAXIMO; –grant create session to MAXIMO with ADMIN OPTION; –grant alter user to MAXIMO; |
3.2. 安装Oracle 12c
3.2.1. 安装数据库软件
选择”创建新Windows用户”,输入口令要满足Windows管理策略(Maximo123),或可以通过gpedit.msc命令禁用密码复杂性策略;
以下文章点击率最高
Loading…