新的Oracle数据库

3

当我创建一个Oracle数据库时,它里面有很多带有奇怪名称的表。这些表是什么?我应该保留它们吗?如果不需要,我如何避免创建它们?

以下是这些表的名称:

LOGMNR_UID$ LOGMNR_SESSION_EVOLVE$ LOGMNR_GLOBAL$ LOGMNR_RESTART_CKPT_TXINFO$ LOGMNR_AGE_SPILL$ LOGMNR_SPILL$ LOGMNRC_DBNAME_UID_MAP LOGMNR_LOG$ LOGMNR_ERROR$ LOGMNR_PROCESSED_LOG$ LOGMNR_FILTER$ LOGMNR_RESTART_CKPT$ LOGMNR_GT_TAB_INCLUDE$ LOGMNR_GT_USER_INCLUDE$ LOGMNRT_MDDL$ OL$ OL$HINTS OL$NODES LOGMNR_DICTSTATE$ LOGMNRC_GTLO LOGMNRC_GTCS LOGMNRC_GSII LOGMNR_SEED$ LOGMNR_DICTIONARY$ LOGMNR_OBJ$ LOGMNR_TAB$ LOGMNR_COL$ LOGMNR_ATTRCOL$ LOGMNR_TS$ LOGMNR_IND$ LOGMNR_USER$ LOGMNR_TABPART$ LOGMNR_TABSUBPART$ LOGMNR_TABCOMPART$ LOGMNR_TYPE$ LOGMNR_COLTYPE$ LOGMNR_ATTRIBUTE$ LOGMNR_LOB$ LOGMNR_CDEF$ LOGMNR_CCOL$ LOGMNR_ICOL$ LOGMNR_LOBFRAG$ LOGMNR_INDPART$ LOGMNR_INDSUBPART$ LOGMNR_INDCOMPART$ LOGMNR_LOGMNR_BUILDLOG LOGMNR_NTAB$ LOGMNR_OPQTYPE$ LOGMNR_SUBCOLTYPE$ LOGMNR_KOPM$ LOGMNR_PROPS$ LOGMNR_ENC$ LOGMNR_REFCON$ LOGMNR_PARTOBJ$ LOGMNRP_CTAS_PART_MAP LOGSTDBY$APPLY_PROGRESS MVIEW$_ADV_OWB DEF$_AQERROR DEF$_AQCALL MVIEW$_ADV_PARTITION MVIEW$_ADV_INDEX HELP SQLPLUS_PRODUCT_PROFILE LOGSTDBY$HISTORY LOGSTDBY$SKIP_SUPPORT LOGSTDBY$SKIP LOGSTDBY$SKIP_TRANSACTION LOGSTDBY$PLSQL LOGSTDBY$FLASHBACK_SCN LOGSTDBY$SCN LOGSTDBY$APPLY_MILESTONE LOGSTDBY$EVENTS LOGSTDBY$PARAMETERS REPCAT$_SITES_NEW REPCAT$_EXTENSION REPCAT$_INSTANTIATION_DDL REPCAT$_EXCEPTIONS REPCAT$_TEMPLATE_TARGETS REPCAT$_RUNTIME_PARMS REPCAT$_SITE_OBJECTS REPCAT$_TEMPLATE_SITES REPCAT$_USER_PARM_VALUES REPCAT$_OBJECT_PARMS REPCAT$_TEMPLATE_PARMS REPCAT$_TEMPLATE_OBJECTS REPCAT$_TEMPLATE_REFGROUPS REPCAT$_OBJECT_TYPES REPCAT$_USER_AUTHORIZATIONS REPCAT$_REFRESH_TEMPLATES REPCAT$_TEMPLATE_TYPES REPCAT$_TEMPLATE_STATUS REPCAT$_FLAVOR_OBJECTS REPCAT$_AUDIT_COLUMN REPCAT$_AUDIT_ATTRIBUTE REPCAT$_PARAMETER_COLUMN REPCAT$_RESOL_STATS_CONTROL REPCAT$_RESOLUTION_STATISTICS REPCAT$_RESOLUTION REPCAT$_RESOLUTION_METHOD REPCAT$_CONFLICT REPCAT$_GROUPED_COLUMN REPCAT$_COLUMN_GROUP REPCAT$_PRIORITY REPCAT$_PRIORITY_GROUP REPCAT$_REPGROUP_PRIVS REPCAT$_DDL REPCAT$_REPCATLOG REPCAT$_REPPROP REPCAT$_GENERATED REPCAT$_KEY_COLUMNS REPCAT$_REPCOLUMN REPCAT$_REPOBJECT REPCAT$_SNAPGROUP REPCAT$_REPSCHEMA REPCAT$_FLAVORS REPCAT$_REPCAT DEF$_PUSHED_TRANSACTIONS DEF$_ORIGIN DEF$_PROPAGATOR DEF$_TEMP$LOB DEF$_LOB DEF$_DEFAULTDEST DEF$_CALLDEST DEF$_DESTINATION DEF$_ERROR AQ$_INTERNET_AGENT_PRIVS AQ$_INTERNET_AGENTS AQ$_SCHEDULES AQ$_QUEUES AQ$_QUEUE_TABLES MVIEW$_ADV_PLAN MVIEW$_ADV_JOURNAL MVIEW$_ADV_INFO MVIEW$_ADV_PARAMETERS MVIEW$_ADV_EXCEPTIONS MVIEW$_ADV_OUTPUT MVIEW$_ADV_ELIGIBLE MVIEW$_ADV_CLIQUE MVIEW$_ADV_GC MVIEW$_ADV_FJG MVIEW$_ADV_AJG MVIEW$_ADV_ROLLUP MVIEW$_ADV_LEVEL MVIEW$_ADV_FILTERINSTANCE MVIEW$_ADV_LOG MVIEW$_ADV_FILTER MVIEW$_ADV_TEMP MVIEW$_ADV_PRETTY MVIEW$_ADV_SQLDEPEND MVIEW$_ADV_BASETABLE MVIEW$_ADV_WORKLOAD LOGMNR_SESSION$ LOGMNR_PARAMETER$

通常,您是想要它们所有含义的列表吗? - skaffman
不,我想知道我是否需要全部。 - Shayan
3
他们不是为了好玩而创造它们的。如果你不确定,不要动它们。 - Gary Myers
2个回答

8

6
它被称为数据字典,在其中Oracle存储其模块和表的信息。请参阅Oracle文档
如果您选择自定义安装,可以选择不安装模块,这会使您获得更少的模块和更小的数据字典。

网页内容由stack overflow 提供, 点击上面的
可以查看英文原文,
原文链接