初始化数据库的oracle的脚本要怎么写

Choerodon Choerodon Framework
#1

看了下文档，初始化数据库的，只有mysql格式的，
并且发现manager-service的提供的liquibase脚本，没有序列。

#2

%E5%9B%BE%E7%89%87
%E5%9B%BE%E7%89%871360×686 46.5 KB

初始化iam数据脚本，中间一直提示这个错
%E5%9B%BE%E7%89%87
%E5%9B%BE%E7%89%87705×311 15.3 KB

运行脚本

#3

抱歉，更新完，看到manager_serivice的序列了

#4

报ORA-OO942是你这个用户的权限不够，用dba给这个用户加上如下权限就行了
GRANT select ON V_$PARAMETER TO manager_service;

#5

贴一个我测试时的建库建表脚本

CREATE BIGFILE TABLESPACE iam_space
  DATAFILE 'iam_space.dat'
    SIZE 200M
    AUTOEXTEND ON NEXT 20M MAXSIZE 500M;
CREATE TEMPORARY TABLESPACE iam_space_temp
  TEMPFILE 'iam_space_temp.dbf'
  SIZE 200M
  AUTOEXTEND ON NEXT 20M MAXSIZE 500M;
CREATE USER iam_service
  IDENTIFIED BY 123456
  DEFAULT TABLESPACE iam_space
  TEMPORARY TABLESPACE iam_space_temp
  QUOTA 200M on iam_space;

GRANT create session TO iam_service;
GRANT create table TO iam_service;
GRANT create view TO iam_service;
GRANT create any trigger TO iam_service;
GRANT create any procedure TO iam_service;
GRANT create sequence TO iam_service;
GRANT create synonym TO iam_service;
GRANT select ON V_$PARAMETER TO iam_service;