Database Schemas Checklist

When not using auto-generated database schema modes it is necessary to create empty schemas manually using database user with DBA privileges

AppBase has 3 schema types: Registry, Tenant, Environment

This section has information how to create each of 3 schema types. We recommend to create a single tablespace to be used by all AppBase database schemas.

Tablespace

The table space section relates only to Oracle database

Oracle Database Command

This section explains how to create new tablespace. As an alternative you may use one of the default Oracle tablespaces, for example: USERS or SYSTEM and skip this section.

To create database table space for AppBase modify the command below using the instruction and execute it using any database management tool:

CREATE TABLESPACE @APPBASE_TABLESPACE@
DATAFILE '/u01/app/oracle/oradata/ORA12C/@APPBASE_TABLESPACE@.dbf' SIZE 4096M
AUTOEXTEND ON NEXT 1024M MAXSIZE 32767M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128k
SEGMENT SPACE MANAGEMENT AUTO
LOGGING
ONLINE;

Replace the placeholders in the command:

@APPBASE_TABLESPACE@ - tablespace to create for AppBase. We usually use the same tablespace for all AppBase databases

 

The command to create table space may differ depending on the operation system on which Oracle database is installed and your Oracle paths.

You may need to review and modify path to DATAFILE in the command above to use correct path for your Oracle installation: DATAFILE '/u01/app/oracle/oradata/ORA12C/@APPBASE_TABLESPACE@.dbf'

Registry Schema

1 Create schema

On Oracle and Sql Server databases the commands to create schemas are different

Oracle Database Command

To create registry schema modify the command below using the instruction and execute it using any database management tool:

create user @REGISTRY_SCHEMA@ identified by @REGISTRY_SCHEMA_PASSWORD@ default tablespace @APPBASE_TABLESPACE@;

Replace the placeholders in the command:

@REGISTRY_SCHEMA@ - registry schema name

@REGISTRY_SCHEMA_PASSWORD@ - registry schema password

@APPBASE_TABLESPACE@ - tablespace created for AppBase. We usually use the same tablespace for all AppBase databases

2 Grant Privileges

On Oracle and Sql Server databases the commands to grant privileges are different

Oracle Database Command

To grant privileges to the registry schema modify the command below using the instruction and execute it using any database management tool:

grant CREATE SESSION, CREATE VIEW, CREATE TRIGGER, CREATE TYPE, CREATE CLUSTER, CREATE INDEXTYPE, CREATE OPERATOR, CREATE PROCEDURE, CREATE SEQUENCE, CREATE TABLE to @REGISTRY_SCHEMA@

When using previous AppBase 6.5 GA release please instead use this command:

grant CONNECT, RESOURCE, CREATE ANY INDEX, CREATE ANY VIEW, CREATE ANY TRIGGER, CREATE ANY TYPE to @REGISTRY_SCHEMA@

 

Replace the placeholders in the command:

@REGISTRY_SCHEMA@ - registry schema name

3 Grant Tablespace Quota

On Oracle and Sql Server databases the commands to grant privileges are different

Oracle Database Command

To grant quote to the registry schema on the registry database table space modify the command below using the instruction and execute it using any database management tool:

 alter user @REGISTRY_SCHEMA@ quota 512M on @APPBASE_TABLESPACE@;

Replace the placeholders in the command:

@REGISTRY_SCHEMA@ - registry schema name  

@APPBASE_TABLESPACE@ - tablespace created for AppBase. We usually use the same tablespace for all AppBase databases 

Tenant Schema 

1 Create schema

 

On Oracle and Sql Server databases the commands to create schemas are different

Oracle Database Command
To create tenant schema modify the command below using the instruction and execute it using any database management tool:

 

create user @TENANT_SCHEMA@ identified by @TENANT_SCHEMA_PASSWORD@ default tablespace @APPBASE_TABLESPACE@;

Replace the placeholders in the command:

@TENANT_SCHEMA@ - tenant schema name
@TENANT_SCHEMA_PASSWORD@ - tenant schema password
@APPBASE_TABLESPACE@ - tablespace created for AppBase. We usually use the same tablespace for all AppBase databases

2 Grant Privileges

On Oracle and Sql Server databases the commands to grant privileges are different
Oracle Database Command
To grant privileges to the tenant schema modify the command below using the instruction and execute it using any database management tool:

 

grant CREATE SESSION, CREATE VIEW, CREATE TRIGGER, CREATE TYPE, CREATE CLUSTER, CREATE INDEXTYPE, CREATE OPERATOR, CREATE PROCEDURE, CREATE SEQUENCE, CREATE TABLE to @TENANT_SCHEMA@

When using previous AppBase 6.5 GA release please instead use this command:

grant CONNECT, RESOURCE, CREATE ANY INDEX, CREATE ANY VIEW, CREATE ANY TRIGGER, CREATE ANY TYPE to @TENANT_SCHEMA@

 

Replace the placeholders in the command:

@TENANT_SCHEMA@ - tenant schema name

3 Grant Tablespace Quota

On Oracle and Sql Server databases the commands to grant privileges are different

Oracle Database Command

To grant quote to the tenant schema on the tenant database table space modify the command below using the instruction and execute it using any database management tool:

alter user @TENANT_SCHEMA@ quota 1G on @APPBASE_TABLESPACE@;

Replace the placeholders in the command:

@TENANT_SCHEMA@ - tenant schema name 

@APPBASE_TABLESPACE@ - tablespace created for AppBase. We usually use the same tablespace for all AppBase databases 

Environment Schema

1 Create schema

On Oracle and Sql Server databases the commands to create schemas are different
Oracle Database Command

To create environment schema modify the command below using the instruction and execute it using any database management tool:

create user @ENVIRONMENT_SCHEMA@ identified by @ENVIRONMENT_SCHEMA_PASSWORD@ default tablespace @APPBASE_TABLESPACE@;

Replace the placeholders in the command:

@ENVIRONMENT_SCHEMA@ - environment schema name
@ENVIRONMENT_SCHEMA_PASSWORD@ - environment schema password
@APPBASE_TABLESPACE@ - tablespace created for AppBase. We usually use the same tablespace for all AppBase databases

2 Grant Privileges

On Oracle and Sql Server databases the commands to grant privileges are different

Oracle Database Command

To grant privileges to the environment schema modify the command below using the instruction and execute it using any database management tool:

grant CREATE SESSION, CREATE VIEW, CREATE TRIGGER, CREATE TYPE, CREATE CLUSTER, CREATE INDEXTYPE, CREATE OPERATOR, CREATE PROCEDURE, CREATE SEQUENCE, CREATE TABLE to @ENVIRONMENT_SCHEMA@

When using previous AppBase 6.5 GA release please instead use this command:

grant CONNECT, RESOURCE, CREATE ANY INDEX, CREATE ANY VIEW, CREATE ANY TRIGGER, CREATE ANY TYPE to @ENVIRONMENT_SCHEMA@

Replace the placeholders in the command:

@ENVIRONMENT_SCHEMA@ - environment schema name

3 Grant Tablespace Quota

On Oracle and Sql Server databases the commands to grant privileges are different

Oracle Database Command

To grant quote to the environment schema on the environment database table space modify the command below using the instruction and execute it using any database management tool:

alter user @ENVIRONMENT_SCHEMA@ quota 1G on @APPBASE_TABLESPACE@;

Replace the placeholders in the command:
@ENVIRONMENT_SCHEMA@ - environment schema name
@APPBASE_TABLESPACE@ - tablespace created for AppBase. We usually use the same tablespace for all AppBase databases


4 Database System Packages

This section is for Oracle database only

 

Following packages must be installed in order for AppBase to function properly.

 

DBMSHSXP
DBMSZEXP_SYSPKGGRNT
DBMS_ADDM
DBMS_ADR
DBMS_ADR_APP
DBMS_ADR_INTERNAL
DBMS_ADVANCED_REWRITE
DBMS_ADVISOR
DBMS_ALERT
DBMS_APBACKEND
DBMS_APPLICATION_INFO
DBMS_APPLY_ADM
DBMS_APPLY_ADM_INTERNAL
DBMS_APPLY_ADM_IVK
DBMS_APPLY_ERROR
DBMS_APPLY_HANDLER_ADM
DBMS_APPLY_HANDLER_INTERNAL
DBMS_APPLY_POSITION
DBMS_APPLY_PROCESS
DBMS_APP_CONT
DBMS_APP_CONT_PRVT
DBMS_AQ
DBMS_AQADM
DBMS_AQADM_INV
DBMS_AQADM_SYS
DBMS_AQADM_SYSCALLS
DBMS_AQADM_VAR
DBMS_AQELM
DBMS_AQIN
DBMS_AQJMS
DBMS_AQJMS_INTERNAL
DBMS_AQ_BQVIEW
DBMS_AQ_EXP_CMT_TIME_TABLES
DBMS_AQ_EXP_DEQUEUELOG_TABLES
DBMS_AQ_EXP_HISTORY_TABLES
DBMS_AQ_EXP_INDEX_TABLES
DBMS_AQ_EXP_QUEUES
DBMS_AQ_EXP_QUEUE_TABLES
DBMS_AQ_EXP_SIGNATURE_TABLES
DBMS_AQ_EXP_SUBSCRIBER_TABLES
DBMS_AQ_EXP_TIMEMGR_TABLES
DBMS_AQ_EXP_ZECURITY
DBMS_AQ_IMPORT_INTERNAL
DBMS_AQ_IMP_INTERNAL
DBMS_AQ_IMP_ZECURITY
DBMS_AQ_INV
DBMS_AQ_SYS_EXP_ACTIONS
DBMS_AQ_SYS_EXP_INTERNAL
DBMS_AQ_SYS_IMP_INTERNAL
DBMS_ARCH_PROVIDER_INTL
DBMS_ASH_INTERNAL
DBMS_ASSERT
DBMS_AUDIT_MGMT
DBMS_AUDIT_UTIL
DBMS_AUTOTASK_PRVT
DBMS_AUTO_REPORT
DBMS_AUTO_REPORT_INTERNAL
DBMS_AUTO_SQLTUNE
DBMS_AUTO_TASK
DBMS_AUTO_TASK_ADMIN
DBMS_AUTO_TASK_EXPORT
DBMS_AUTO_TASK_IMMEDIATE
DBMS_AW
DBMS_AWR_REPORT_LAYOUT
DBMS_AW_EXP
DBMS_AW_STATS
DBMS_BACKUP_RESTORE
DBMS_CACHEUTIL
DBMS_CAPTURE_ADM
DBMS_CAPTURE_ADM_INTERNAL
DBMS_CAPTURE_ADM_IVK
DBMS_CAPTURE_PROCESS
DBMS_CAPTURE_SWITCH_ADM
DBMS_CAPTURE_SWITCH_INTERNAL
DBMS_CDC_DPUTIL
DBMS_CDC_EXPDP
DBMS_CDC_EXPVDP
DBMS_CDC_IMPDP
DBMS_CDC_IMPDPV
DBMS_CDC_IPUBLISH
DBMS_CDC_ISUBSCRIBE
DBMS_CDC_PUBLISH
DBMS_CDC_SUBSCRIBE
DBMS_CDC_SYS_IPUBLISH
DBMS_CDC_UTILITY
DBMS_CHANGE_NOTIFICATION
DBMS_CLIENT_RESULT_CACHE
DBMS_CLOBUTIL
DBMS_CMP_INT
DBMS_COMPARISON
DBMS_COMPRESSION
DBMS_CONNECTION_POOL
DBMS_CREDENTIAL
DBMS_CRYPTO
DBMS_CRYPTO_FFI
DBMS_CRYPTO_INTERNAL
DBMS_CRYPTO_TOOLKIT
DBMS_CRYPTO_TOOLKIT_FFI
DBMS_CRYPTO_TOOLKIT_TYPES
DBMS_CSX_ADMIN
DBMS_CSX_INT
DBMS_CSX_INT2
DBMS_CUBE_LOG
DBMS_DATAPUMP
DBMS_DATAPUMP_INT
DBMS_DATAPUMP_UTL
DBMS_DATA_MINING
DBMS_DATA_MINING_INTERNAL
DBMS_DATA_MINING_TRANSFORM
DBMS_DBCOMP
DBMS_DBFS_CONTENT
DBMS_DBFS_CONTENT_ADMIN
DBMS_DBFS_CONTENT_SPI
DBMS_DBFS_HS
DBMS_DBFS_SFS
DBMS_DBFS_SFS_ADMIN
DBMS_DBVERIFY
DBMS_DB_VERSION
DBMS_DDL
DBMS_DDL_INTERNAL
DBMS_DEBUG
DBMS_DEBUG_JDWP
DBMS_DEBUG_JDWP_CUSTOM
DBMS_DEFER_IMPORT_INTERNAL
DBMS_DESCRIBE
DBMS_DG
DBMS_DIMENSION
DBMS_DISRUPT
DBMS_DISTRIBUTED_TRUST_ADMIN
DBMS_DM_EXP_INTERNAL
DBMS_DM_MODEL_EXP
DBMS_DM_MODEL_IMP
DBMS_DM_UTIL
DBMS_DNFS
DBMS_DRS
DBMS_DST
DBMS_EDITIONS_UTILITIES
DBMS_EPG
DBMS_ERRLOG
DBMS_EXPORT_EXTENSION
DBMS_EXPORT_EXTENSION_I
DBMS_EXTENDED_TTS_CHECKS
DBMS_FBT
DBMS_FEATURE_USAGE
DBMS_FEATURE_USAGE_INTERNAL
DBMS_FEATURE_USAGE_REPORT
DBMS_FGA
DBMS_FILE_GROUP
DBMS_FILE_GROUP_DECL
DBMS_FILE_GROUP_EXP
DBMS_FILE_GROUP_EXP_INTERNAL
DBMS_FILE_GROUP_IMP
DBMS_FILE_GROUP_IMP_INTERNAL
DBMS_FILE_GROUP_INTERNAL_INVOK
DBMS_FILE_GROUP_UTL
DBMS_FILE_GROUP_UTL_INVOK
DBMS_FILE_TRANSFER
DBMS_FIX_CONTROL_PERSISTENCE
DBMS_FLASHBACK
DBMS_FLASHBACK_ARCHIVE
DBMS_FREQUENT_ITEMSET
DBMS_FS
DBMS_FUSE
DBMS_GOLDENGATE_ADM
DBMS_GOLDENGATE_ADM_INTERNAL
DBMS_GOLDENGATE_ADM_INT_INVOK
DBMS_GOLDENGATE_AUTH
DBMS_GOLDENGATE_EXP
DBMS_GOLDENGATE_IMP
DBMS_GSM_FIX
DBMS_GSM_FIXED
DBMS_HADOOP
DBMS_HADOOP_INTERNAL
DBMS_HANG_MANAGER
DBMS_HA_ALERTS
DBMS_HA_ALERTS_PRVT
DBMS_HEAT_MAP
DBMS_HEAT_MAP_INTERNAL
DBMS_HIERARCHY
DBMS_HM
DBMS_HPROF
DBMS_HS
DBMS_HS_ALT
DBMS_HS_CHK
DBMS_HS_PARALLEL
DBMS_HS_PARALLEL_METADATA
DBMS_HS_UTL
DBMS_IJOB
DBMS_ILM
DBMS_ILM_ADMIN
DBMS_INDEX_UTL
DBMS_INMEMORY
DBMS_INMEMORY_ADMIN
DBMS_INTERNAL_LOGSTDBY
DBMS_INTERNAL_ROLLING
DBMS_INTERNAL_SAFE_SCN
DBMS_INTERNAL_TRIGGER
DBMS_IR
DBMS_IREFRESH
DBMS_IREFSTATS
DBMS_ISCHED
DBMS_ISCHED_CHAIN_CONDITION
DBMS_ISCHED_REMDB_JOB
DBMS_ISCHED_REMOTE_ACCESS
DBMS_ISNAPSHOT
DBMS_ISYNCREF
DBMS_ITRIGGER_UTL
DBMS_I_INDEX_UTL
DBMS_JAVA
DBMS_JAVASCRIPT
DBMS_JAVA_DEFINERS
DBMS_JAVA_DUMP
DBMS_JAVA_MISC
DBMS_JAVA_TEST
DBMS_JMS_PLSQL
DBMS_JOB
DBMS_JSON
DBMS_JSON0
DBMS_JSON_INT
DBMS_JVM_EXP_PERMS
DBMS_LCR
DBMS_LDAP
DBMS_LDAP_API_FFI
DBMS_LDAP_UTL
DBMS_LOB
DBMS_LOBUTIL
DBMS_LOB_AM_PRIVATE
DBMS_LOCK
DBMS_LOG
DBMS_LOGMNR
DBMS_LOGMNR_D
DBMS_LOGMNR_INTERNAL
DBMS_LOGMNR_LOGREP_DICT
DBMS_LOGMNR_SESSION_INT
DBMS_LOGREP_DEF_PROC_UTL
DBMS_LOGREP_EXP
DBMS_LOGREP_IMP
DBMS_LOGREP_IMP_INTERNAL
DBMS_LOGREP_UTIL
DBMS_LOGREP_UTIL_INVOK
DBMS_LOGSTDBY
DBMS_LOGSTDBY_CONTEXT
DBMS_MANAGEMENT_BOOTSTRAP
DBMS_MANAGEMENT_PACKS
DBMS_MASTER_TABLE
DBMS_MDX_ODBO
DBMS_METADATA
DBMS_METADATA_BUILD
DBMS_METADATA_DIFF
DBMS_METADATA_DPBUILD
DBMS_METADATA_HACK
DBMS_METADATA_INT
DBMS_METADATA_UTIL
DBMS_MONITOR
DBMS_MVIEW_STATS
DBMS_MVIEW_STATS_INTERNAL
DBMS_NETWORK_ACL_ADMIN
DBMS_NETWORK_ACL_UTILITY
DBMS_OBFUSCATION_TOOLKIT
DBMS_OBFUSCATION_TOOLKIT_FFI
DBMS_OBJECTS_APPS_UTILS
DBMS_OBJECTS_UTILS
DBMS_ODCI
DBMS_OUTPUT
DBMS_PARALLEL_EXECUTE
DBMS_PARALLEL_EXECUTE_INTERNAL
DBMS_PART
DBMS_PCLXUTIL
DBMS_PCLXUTIL_INTERNAL
DBMS_PDB
DBMS_PDB_ALTER_SHARING
DBMS_PERF
DBMS_PICKLER
DBMS_PIPE
DBMS_PITR
DBMS_PLSQL_CODE_COVERAGE
DBMS_PLUGTS
DBMS_PLUGTSP
DBMS_PQ_INTERNAL
DBMS_PREDICTIVE_ANALYTICS
DBMS_PREPLUGIN_BACKUP
DBMS_PREPROCESSOR
DBMS_PRIVILEGE_CAPTURE
DBMS_PRIV_CAPTURE
DBMS_PROCESS
DBMS_PROFILER
DBMS_PROPAGATION_ADM
DBMS_PROPAGATION_INTERNAL
DBMS_PRVTAQIM
DBMS_PRVTAQIP
DBMS_PRVTAQIS
DBMS_PRVTRMIE
DBMS_PRVTSQDS
DBMS_PRVTSQIS
DBMS_PRVT_TRACE
DBMS_PSP
DBMS_PSWMG_IMPORT
DBMS_QOPATCH
DBMS_RANDOM
DBMS_RAT_MASK
DBMS_RCVMAN
DBMS_RECOVERABLE_SCRIPT
DBMS_RECO_SCRIPT_INT
DBMS_RECO_SCRIPT_INVOK
DBMS_REDACT
DBMS_REDACT_INT
DBMS_REDEFINITION
DBMS_REDEFINITION_INTERNAL
DBMS_REFRESH
DBMS_REGISTRY
DBMS_REGISTRY_SERVER
DBMS_REGISTRY_SIMPLE
DBMS_REGISTRY_SYS
DBMS_REGXDB
DBMS_REPAIR
DBMS_REPCAT
DBMS_REPCAT_MIG
DBMS_REPORT
DBMS_REPUTIL
DBMS_RESCONFIG
DBMS_RESOURCE_MANAGER
DBMS_RESOURCE_MANAGER_PRIVS
DBMS_RESULT_CACHE
DBMS_RESULT_CACHE_API
DBMS_RESULT_CACHE_INTERNAL
DBMS_RESUMABLE
DBMS_RLS
DBMS_RLS_INT
DBMS_RMGR_GROUP_EXPORT
DBMS_RMGR_PACT_EXPORT
DBMS_RMGR_PLAN_EXPORT
DBMS_RMIN
DBMS_RMIN_SYS
DBMS_ROLLING
DBMS_ROWID
DBMS_RULE
DBMS_RULEADM_INTERNAL
DBMS_RULE_ADM
DBMS_RULE_EXIMP
DBMS_RULE_EXP_EC_INTERNAL
DBMS_RULE_EXP_EV_CTXS
DBMS_RULE_EXP_RL_INTERNAL
DBMS_RULE_EXP_RS_INTERNAL
DBMS_RULE_EXP_RULES
DBMS_RULE_EXP_RULE_SETS
DBMS_RULE_EXP_UTL
DBMS_RULE_EXP_UTLI
DBMS_RULE_IMP_OBJ
DBMS_RULE_INTERNAL
DBMS_SCHEDULER
DBMS_SCHED_ARGUMENT_IMPORT
DBMS_SCHED_ATTRIBUTE_EXPORT
DBMS_SCHED_CHAIN_EXPORT
DBMS_SCHED_CLASS_EXPORT
DBMS_SCHED_CONSTRAINT_EXPORT
DBMS_SCHED_CREDENTIAL_EXPORT
DBMS_SCHED_EXPORT_CALLOUTS
DBMS_SCHED_FILE_WATCHER_EXPORT
DBMS_SCHED_JOB_EXPORT
DBMS_SCHED_MAIN_EXPORT
DBMS_SCHED_PROGRAM_EXPORT
DBMS_SCHED_SCHEDULE_EXPORT
DBMS_SCHED_WINDOW_EXPORT
DBMS_SCHED_WINGRP_EXPORT
DBMS_SCN
DBMS_SECUREFILE_LOG_ADMIN
DBMS_SERVER_ALERT
DBMS_SERVER_ALERT_EXPORT
DBMS_SERVER_ALERT_PRVT
DBMS_SERVER_TRACE
DBMS_SERVICE
DBMS_SERVICE_CONST
DBMS_SERVICE_ERR
DBMS_SERVICE_PRVT
DBMS_SESSION
DBMS_SESSION_STATE
DBMS_SHARED_POOL
DBMS_SMB
DBMS_SMB_INTERNAL
DBMS_SNAPSHOT
DBMS_SNAPSHOT_COMMON
DBMS_SNAPSHOT_KKXRCA
DBMS_SNAPSHOT_UTL
DBMS_SNAP_INTERNAL
DBMS_SNAP_REPAPI
DBMS_SODA_ADMIN
DBMS_SODA_DML
DBMS_SODA_DOM
DBMS_SODA_UTIL
DBMS_SPACE
DBMS_SPACE_ADMIN
DBMS_SPACE_ALERT
DBMS_SPD
DBMS_SPD_INTERNAL
DBMS_SPM
DBMS_SPM_INTERNAL
DBMS_SQADM_SYSCALLS
DBMS_SQL
DBMS_SQLDIAG
DBMS_SQLDIAG_INTERNAL
DBMS_SQLHASH
DBMS_SQLJTYPE
DBMS_SQLPA
DBMS_SQLPATCH
DBMS_SQLTCB_INTERNAL
DBMS_SQLTUNE
DBMS_SQLTUNE_INTERNAL
DBMS_SQLTUNE_UTIL0
DBMS_SQLTUNE_UTIL1
DBMS_SQLTUNE_UTIL2
DBMS_SQL_MONITOR
DBMS_SQL_TRANSLATOR
DBMS_SQL_TRANSLATOR_EXPORT
DBMS_STANDARD
DBMS_STATS
DBMS_STATS_ADVISOR
DBMS_STATS_INTERNAL
DBMS_STAT_FUNCS
DBMS_STAT_FUNCS_AUX
DBMS_STORAGE_MAP
DBMS_STREAMS
DBMS_STREAMS_ADM
DBMS_STREAMS_ADM_IVK
DBMS_STREAMS_ADM_UTL
DBMS_STREAMS_ADM_UTL_INT
DBMS_STREAMS_ADM_UTL_INVOK
DBMS_STREAMS_ADVISOR_ADM
DBMS_STREAMS_ADV_ADM_UTL
DBMS_STREAMS_ADV_ADM_UTL_INVOK
DBMS_STREAMS_AUTH
DBMS_STREAMS_AUTO_INT
DBMS_STREAMS_CDC_ADM
DBMS_STREAMS_CONTROL_ADM
DBMS_STREAMS_DATAPUMP
DBMS_STREAMS_DATAPUMP_UTIL
DBMS_STREAMS_DECL
DBMS_STREAMS_HANDLER_ADM
DBMS_STREAMS_HANDLER_INTERNAL
DBMS_STREAMS_LCR_INT
DBMS_STREAMS_MC
DBMS_STREAMS_MC_INV
DBMS_STREAMS_MESSAGING
DBMS_STREAMS_MT
DBMS_STREAMS_PUB_RPC
DBMS_STREAMS_RPC
DBMS_STREAMS_RPC_INTERNAL
DBMS_STREAMS_SM
DBMS_STREAMS_TABLESPACE_ADM
DBMS_STREAMS_TBS_INT
DBMS_STREAMS_TBS_INT_INVOK
DBMS_SUMMARY
DBMS_SUMREF_UTIL
DBMS_SUMVDM
DBMS_SUM_RWEQ_EXPORT
DBMS_SUM_RWEQ_EXPORT_INTERNAL
DBMS_SWRF_INTERNAL
DBMS_SWRF_REPORT_INTERNAL
DBMS_SYNC_REFRESH
DBMS_SYNC_REFRESH_INTERNAL
DBMS_SYSTEM
DBMS_SYS_ERROR
DBMS_SYS_SQL
DBMS_TDB
DBMS_TDE_TOOLKIT
DBMS_TDE_TOOLKIT_FFI
DBMS_TF
DBMS_TG_DBG
DBMS_TNS
DBMS_TRACE
DBMS_TRANSACTION
DBMS_TRANSACTION_INTERNAL_SYS
DBMS_TRANSFORM
DBMS_TRANSFORM_EXIMP
DBMS_TRANSFORM_EXIMP_INTERNAL
DBMS_TRANSFORM_INTERNAL
DBMS_TSDP_MANAGE
DBMS_TSDP_PROTECT
DBMS_TTS
DBMS_TYPES
DBMS_TYPE_UTILITY
DBMS_UMF
DBMS_UMF_INTERNAL
DBMS_UMF_PROTECTED
DBMS_UNDO_ADV
DBMS_UTILITY
DBMS_WARNING
DBMS_WARNING_INTERNAL
DBMS_WLM
DBMS_WORKLOAD_CAPTURE
DBMS_WORKLOAD_REPLAY
DBMS_WORKLOAD_REPOSITORY
DBMS_WRR_INTERNAL
DBMS_WRR_PROTECTED
DBMS_WRR_STATE
DBMS_XA
DBMS_XDB
DBMS_XDBNFS
DBMS_XDBREPOS
DBMS_XDBRESOURCE
DBMS_XDBT
DBMS_XDBUTIL_INT
DBMS_XDBZ
DBMS_XDBZ0
DBMS_XDB_ADMIN
DBMS_XDB_CONFIG
DBMS_XDB_CONSTANTS
DBMS_XDB_CONTENT
DBMS_XDB_PRINT
DBMS_XDB_REPOS
DBMS_XDB_UTIL
DBMS_XDB_VERSION
DBMS_XDS
DBMS_XEVENT
DBMS_XLSB
DBMS_XMLDOM
DBMS_XMLDOM_ICD
DBMS_XMLGEN
DBMS_XMLINDEX
DBMS_XMLINDEX0
DBMS_XMLPARSER
DBMS_XMLQUERY
DBMS_XMLSAVE
DBMS_XMLSCHEMA
DBMS_XMLSCHEMA_ANNOTATE
DBMS_XMLSCHEMA_INT
DBMS_XMLSCHEMA_LSB
DBMS_XMLSTORAGE_MANAGE
DBMS_XMLSTORE
DBMS_XMLTRANSLATIONS
DBMS_XPLAN
DBMS_XQUERY
DBMS_XQUERYINT
DBMS_XRWMV
DBMS_XSLPROCESSOR
DBMS_XSTREAM_ADM
DBMS_XSTREAM_ADM_INTERNAL
DBMS_XSTREAM_ADM_UTL
DBMS_XSTREAM_AUTH
DBMS_XSTREAM_AUTH_IVK
DBMS_XSTREAM_GG
DBMS_XSTREAM_GG_ADM
DBMS_XSTREAM_GG_INTERNAL
DBMS_XSTREAM_UTL_IVK
DBMS_XS_FIDM
DBMS_XS_MTCACHE
DBMS_XS_PRINCIPALS
DBMS_XS_SESSIONS
DBMS_XS_SESSIONS_FFI
DBMS_XS_SIDP
DBMS_XS_SYSTEM
DBMS_XS_SYSTEM_FFI
DBMS_ZHELP
DBMS_ZHELP_IR

 



  • No labels