上一主题: 附录:卸载 CA Business Service Insight

下一主题: 用户指南

附录:CA Technologies 针对数据库对象的命名约定策略

下表中列出的清单说明了 CA Technologies 的命名约定策略。 如果您的数据库命名约定不同于 CA Technologies 的策略,请采用不同的命名约定填充相应的行。 请在运行安装之前咨询 CA 支持部门。

CA 命名约定

客户命名约定

表空间

 

TBS_ACE_DATA_TAB_01

 

TBS_ACE_INDEX_TAB_01

 

TBS_CSL_DATA_TAB_01

 

TBS_CSL_INDEX_TAB_01

 

TBS_DASH_DATA_01

 

TBS_DASH_INDEX_01

 

TBS_LOB_DATA_01

 

TBS_OBL_DATA_01

 

TBS_OBL_INDEX_01

 

TBS_PSL_DATA_TAB_01

 

TBS_PSL_INDEX_TAB_01

 

TBS_OBLIDBADMIN_01

 

TBS_SLA_DATA_01

 

TBS_SLA_DATA_02

 

TBS_SLA_INDEX_01

 

TBS_SLA_INDEX_02

 

TBS_SMI_DATA_TAB_01

 

TBS_SMI_INDEX_TAB_01

 

TBS_SMIANA_DATA_TAB_01

 

TBS_SMIANA_INDEX_TAB_01

 

CA TECHNOLOGIES USERS

 

OBLICORE

 

OBLIDBADMIN

 

OBLIDBADMIN PRIVILEGES

 

CONNECT TO OBLIDBADMIN

 

UNLIMITED TABLESPACE TO OBLIDBADMIN

 

EXECUTE ON DBMS_LOCKTO OBLIDBADMIN

 

SELECT ANY DICTIONARY TO OBLIDBADMIN

 

CREATE PUBLIC SYNONYM TO OBLIDBADMIN

 

DROP PUBLIC SYNONYM TO OBLIDBADMIN

 

CREATE ANY SYNONYM TO OBLIDBADMIN

 

DROP ANY SYNONYM TO OBLIDBADMIN

 

CREATE TABLE TO OBLIDBADMIN

 

CREATE VIEW TO OBLIDBADMIN

 

CREATE SEQUENCE TO OBLIDBADMIN

 

ROLE_USR_REG_PRIVS TO OBLIDBADMIN WITH ADMIN OPTION

 

ALTER DATABASE TO OBLIDBADMIN

 

ALTER SESSION TO OBLIDBADMIN

 

EXECUTE ANY PROCEDURE TO OBLIDBADMIN

 

SELECT ANY TABLE TO OBLIDBADMIN

 

GRANT ANY OBJECT PRIVILEGE TO OBLIDBADMIN

 

GRANT ANY PRIVILEGE TO OBLIDBADMIN

 

CREATE TABLESPACE TO OBLIDBADMIN

 

ALTER TABLESPACE TO OBLIDBADMIN

 

DROP TABLESPACE TO OBLIDBADMIN

 

CREATE USER TO OBLIDBADMIN

 

ALTER USER TO OBLIDBADMIN

 

DROP USER TO OBLIDBADMIN

 

CREATE ROLE TO OBLIDBADMIN

 

ALTER ANY ROLE TO OBLIDBADMIN

 

DROP ANY ROLE TO OBLIDBADMIN

 

CREATE ANY TABLE TO OBLIDBADMIN

 

ALTER ANY TABLE TO OBLIDBADMIN

 

DROP ANY TABLE TO OBLIDBADMIN

 

CREATE ANY INDEX TO OBLIDBADMIN

 

ALTER ANY INDEX TO OBLIDBADMIN

 

DROP ANY INDEX TO OBLIDBADMIN

 

CREATE ANY PROCEDURE TO OBLIDBADMIN

 

ALTER ANY PROCEDURE TO OBLIDBADMIN

 

DROP ANY PROCEDURE TO OBLIDBADMIN

 

CREATE ANY SEQUENCE TO OBLIDBADMIN

 

ALTER ANY SEQUENCE TO OBLIDBADMIN

 

DROP ANY SEQUENCE TO OBLIDBADMIN

 

CREATE ANY TRIGGER TO OBLIDBADMIN

 

ALTER ANY TRIGGER TO OBLIDBADMIN

 

DROP ANY TRIGGER TO OBLIDBADMIN

 

CREATE ANY TYPE TO OBLIDBADMIN

 

DROP ANY TYPE TO OBLIDBADMIN

 

CREATE ANY VIEW TO OBLIDBADMIN

 

DROP ANY VIEW TO OBLIDBADMIN

 

USRACE

 

USRCSL

 

USRDASH

 

USREDR

 

USRMTN

 

USRPSL

 

USRRPT

 

USRSLA

 

OBLICORE PRIVILEGES

 

CONNECT TO OBLICORE

 

UNLIMITED TABLESPACE TO OBLICORE

 

EXECUTE ON DBMS_LOCK TO OBLICORE

 

SELECT ANY DICTIONARY TO OBLICORE

 

CREATE PUBLIC SYNONYM TO OBLICORE

 

DROP PUBLIC SYNONYM TO OBLICORE

 

CREATE ANY SYNONYM TO OBLICORE

 

DROP ANY SYNONYM TO OBLICORE

 

CREATE TABLE TO OBLICORE

 

CREATE VIEW TO OBLICORE

 

CREATE SEQUENCE TO OBLICORE

 

CREATE SESSION TO USRCSL

 

ROLE_USR_REG_PRIVS TO USRCSL

 

CREATE SESSION TO USRDASH

 

ROLE_USR_REG_PRIVS TO USRDASH

 

CREATE SESSION TO USREDR

 

ROLE_USR_REG_PRIVS TO USREDR

 

CREATE SESSION TO USRMTN

 

ROLE_USR_REG_PRIVS TO USRMTN

 

CREATE SESSION TO USRPSL

 

ROLE_USR_REG_PRIVS TO USRPSL

 

CREATE SESSION TO USRRPT

 

ROLE_USR_REG_PRIVS TO USRRPT

 

CREATE SESSION TO USRSLA

 

ROLE_USR_REG_PRIVS TO USRSLA

 

OBLICORE ROLE

 

ROLE_USR_REG_PRIVS

 

PART_MNG_PKG

用于原始数据分区。 如果系统不使用此功能,那么不必运行它。

DB_MNG_FORECAST_PKG -

预测计算。 如果系统不使用此功能,那么不必运行它。 开发此功能是为了在 T_PSL 上使用分区,但 T_PSL 从未激活,所以当前该功能并未投入使用。

DB_MTN_PKG.LOG_PURGE -

用于清除 t_log 表

DB_MTN_PKG.COLLECT_STATS -

数据库统计收集

PRC_T_INTER_REGISTRATIONS_FLAT -

生成一个表,该表利用事件复用性在所有度量标准之间建立了(直接和间接的)连接。 为使用了事件复用性的原始数据报告提供服务。