新的 Oracle 数据库
当我创建 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$提示 OL$节点 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 帮助 SQLPLUS_PRODUCT_PROFILE LOGSTDBY$历史记录 LOGSTDBY$SKIP_SUPPORT LOGSTDBY$SKIP LOGSTDBY$SKIP_TRANSACTION LOGSTDBY$PLSQL LOGSTDBY$FLASHBACK_SCN LOGSTDBY$SCN LOGSTDBY$APPLY_MILESTONE LOGSTDBY$事件 LOGSTDBY$参数 REPCAT$_SITES_NEW REPCAT$_EXTENSION REPCAT$_INSTANTIATION_DDL REPCAT$_例外 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$_冲突 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$_REPSSCHEMA 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$
When I create an Oracle database it has a lot of tables in it with strange names. What are these tables? Should I keep them? If not, how can I avoid creating them?
These are the table names:
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$
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
您列出的表与 Oracle 的 LogMiner 实用程序< /a>、物化视图 和 高级复制等等。你应该别管这些。
The tables you have listed relate to Oracle's LogMiner utility, Materialized Views and Advanced Replication among other things. You should leave these alone.
它称为数据字典,Oracle 在其中存储有关其模块和表的信息。请参阅 Oracle 文档。
如果选择自定义安装,则可以选择不安装模块。这为您提供了更少的模块和更小的数据字典。
It is called the data dictionary, where Oracle stores information on its modules and tables. See the Oracle documentation.
If you select custom installation, you may select to not install modules. Which gives you less modules, and a smaller data dictionary.