Oracle® Communications Services Gatekeeper System Backup and Restore Guide Release 5.0 Part Number E16624-02 |
|
|
View PDF |
This chapter lists all the tables that are created on first start-up of the Services Gatekeeper database (except deployment-specific tables), and backward-compatible tables.
As an optimization, it is possible to remove tables if your communication services do not require them. Because non-existent tables do not require backing up, this makes your implementation more efficient.
WLS_ACTIVE
BUDGET_CONFIG_TABLE
BUDGET_SERVICE_STATE_TABLE
BULK_MMS_CHUNK_LIST
BULK_MMS_CHUNK_SUB_LIST
BULK_MMS_ORDER_LIST
BULK_PUSH_CHUNK_LIST
BULK_PUSH_ORDER_LIST
BULK_PUSH_CHUNK_SUB_LIST
BULK_SMS_CHUNK_LIST
BULK_SMS_CHUNK_SUB_LIST
BULK_SMS_ORDER_LIST
CC_INTERCEPTOR_DATA
GLOBAL_BUDGET_CONFIG_TABLE
GLOBAL_WLNG_SLAS
LEGACY_SMPP_CONNECTION_STORE
LEGACY_SMPP_NOTIF_STORE
LEGACY_SMPP_SESSION_STORE
MPCC_CALL_LEG_SESSION
MPCC_CALL_SESSION
NATIVE_SMPP_SESSION_STORE
PL_AC_SIP_STATUS
PL_CD_SIP_ADDR_COR
PL_CD_SIP_COR_SUB
PL_CN_PX30_OSA_ASSOCIATOR
PL_CN_PX30_OSA_INFO
PL_CN_SIP_ADDR_COR
PL_CN_SIP_COR_SUB
PL_LEGACY_MM7_NOTIF
PL_LEGACY_MMS_MT
PL_MMS_MO_CONTENT_MMS
PL_MMS_MO_MMS
PL_MMS_MT_DR_MMS
PL_MMS_OFFLINE_NOTIF
PL_MMS_ONLINE_NOTIF
PL_LEGACY_MMS_STATUS
PL_LEGACY_MMS_VASP_ID
PL_LEGACY_MMS_VAS_ID
PL_LEGACY_SMPP_BIND_STORE
PL_MPCC_MEDIA_NOTIF
PL_SMS_ONLINE_NOTIF
PL_SMS_SMPP_MO_SMS
PL_PAYMENT_RESERVATION_DATA
PL_PUSH_PAP_NOTIFICATION_INFO
PL_PX30_AC_UI_CALL_INFO
PL_PX30_UI_CALL_LEG_INFO
PL_SMS_BINARY_NOTIF
PL_SMS_MO_SMS
PL_SMS_OFFLINE_NOTIF
PL_SMS_SMPP_MT_SMS
PL_TL_MLP_TRIGGER_INFO
PL_TPC_INAP
PL_TS_MAP_NETWRK
PL_TS_MAP_NETWRK_ROUTE
PL_TS_MAP_NOTIF
PL_TS_MAP_TRIGGERS
PRES_SIP_NOT
PRES_SIP_SUB
PRES_SIP_URI_MAP
PRM_USERS_BC
SHORTCODE_MAPING_STORE
SLEE_ALARM
SLEE_CHARGING
SLEE_INSTANCE_IDS
SLEE_LICENSE_TPS_LOG
SLEE_PL_MGR_PLUGIN
SLEE_SNMP_CONFIG
SLEE_SNMP_TRAP_RECEIVERS
SLEE_STATISTICS_DATA
SLEE_SUPPORTED_STATISTICS
SMPP_SERVICE_APP_INFO
SLEE_DB_LOCKS
SLEE_LICENSE_TPS_CHECK_STATE
SLEE_STATISTICS_CONFIG
SMPP_SERVICE_MO_CON
TPC_CALL_PARTICIPANTS_INFO
TPC_SIP_CALLSESSION_INFO
WLNG_ACCOUNT_GROUPS
WLNG_APP_ACCOUNTS
WLNG_APP_INSTANCES
WLNG_APP_SESSIONS
WLNG_BLOB_CONFIGURATION
WLNG_CONFIGURATION
WLNG_HTTPPROXY
WLNG_MGMT_USERGROUPS
WLNG_MGMT_USERS
WLNG_PRM_SESSIONS
WLNG_SLA_CUSTOM_XSD
WLNG_SLAS
WLNG_SP_ACCOUNTS
WLNG_SUBSCR_CONTRACTS
If you are using backwards compatible listeners (CORBA-based) for alarms, EDRs, or CDRs, there are additional tables in the database. These tables are not included by default in the out-of-the-box version of Services Gatekeeper.
slee_alarm_config
slee_alarm_params
slee_alarm_severity_mapping
slee_charging_config
slee_charging_listeners
slee_edr_filter_properties
slee_edr_filters
slee_edr_listener_filters
slee_edr_listeners