SDE命令行安装配置

junmail

墨衍会员 · AI 创作全网分发码龄21年

关注

最新推荐文章于 2022-07-25 10:02:09 发布 515 阅读 AI 写同款· GEO 优化 ›

一、创建相关表空间

创建sde表空间

create tablespace sde datafile '%oracle_base%\oradata\acf\sde_01.dbf' size 401m uniform size 1m;

创建sde_mvgdb表空间

create tablespace sde_mvgdb datafile '%oracle_base%\oradata\acf\sde_mvgdb_01.dbf' size 201m uniform size 4m;

二、创建sde用户

create user sde identified by sde default tablespace sde;

三、为sde用户赋予相应权限

1、为sde用户赋角色

GRANT CONNECT,RESOURCE TO SDE;

2、为sde用户赋系统权限

GRANT CREATE INDEXTYPE TO SDE;
GRANT CREATE LIBRARY TO SDE;
GRANT CREATE OPERATOR TO SDE;
GRANT CREATE PROCEDURE TO SDE;
GRANT CREATE PUBLIC SYNONYM TO SDE;
GRANT CREATE SEQUENCE TO SDE;
GRANT CREATE SESSION TO SDE;
GRANT CREATE SYNONYM TO SDE;
GRANT CREATE TABLE TO SDE;
GRANT CREATE TRIGGER TO SDE;
GRANT CREATE TYPE TO SDE;
GRANT CREATE VIEW TO SDE;
GRANT DROP PUBLIC SYNONYM TO SDE;
GRANT SELECT ANY TABLE TO SDE;
GRANT UNLIMITED TABLESPACE TO SDE;

3、为sde用户赋对象权限

GRANT EXECUTE ON "SYS"."DBMS_LOCK" TO "SDE";
GRANT EXECUTE ON "SYS"."DBMS_PIPE" TO "SDE";

四、安装sde软件

五、配置存储

##DATA_DICTIONARY
ATTRIBUTE_BINARY  "BLOB"
B_STORAGE               "PCTFREE 0 INITRANS 4 TABLESPACE sde STORAGE (INITIAL 40K)"
B_INDEX_ROWID           "PCTFREE 0 INITRANS 4 TABLESPACE sde STORAGE (INITIAL 40K) NOLOGGING"
B_INDEX_USER            "PCTFREE 0 INITRANS 4 TABLESPACE sde STORAGE (INITIAL 40K) NOLOGGING"
STATES_TABLE            "INITRANS 4 TABLESPACE sde_mvgdb STORAGE (INITIAL 1M)"
STATES_INDEX            "INITRANS 5 TABLESPACE sde_mvgdb STORAGE (INITIAL 128K) NOLOGGING"
STATE_LINEAGES_TABLE    "PCTFREE 0 INITRANS 4 TABLESPACE sde_mvgdb STORAGE (INITIAL 7M)"
STATE_LINEAGES_INDEX    "PCTFREE 0 INITRANS 4 TABLESPACE sde_mvgdb STORAGE (INITIAL 5M) NOLOGGING"
VERSIONS_TABLE          "INITRANS 4 TABLESPACE sde_mvgdb STORAGE (INITIAL 256K)"
VERSIONS_INDEX          "INITRANS 4 TABLESPACE sde_mvgdb STORAGE (INITIAL 128K) NOLOGGING"
MVTABLES_MODIFIED_TABLE "INITRANS 4 TABLESPACE sde_mvgdb STORAGE (INITIAL 2M)"
MVTABLES_MODIFIED_INDEX "INITRANS 4 TABLESPACE sde_mvgdb STORAGE (INITIAL 2M) NOLOGGING"
XML_INDEX_TAGS_TABLE    "INITRANS 4
#                        TABLESPACE <XML_INDEX_TAGS table tablespace name>
                         STORAGE (INITIAL 1M)"
XML_INDEX_TAGS_INDEX    "INITRANS 5
#                        TABLESPACE <XML_INDEX_TAGS table's index tablespace name>
                         STORAGE (INITIAL 1M)"
END