名称中带有 $ 的 Oracle 表
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/13799345/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Oracle tables with $ in name
提问by Gumowy Kaczak
In Sql Developer under tables I see tables, but some of the tables have $ in name.
在表下的 Sql Developer 中，我看到了表，但有些表的名称为 $。
Example:
例子：
tb$something
What does that '$' sign mean when in name of table?
表名中的“$”符号是什么意思？
采纳答案by DazzaL
it doesn't mean anything. as you can create tables with dollar signs in if you want (probably not recommended as people may get confused thinking they are oracle special tables).
这并不意味着什么。因为您可以根据需要创建带有美元符号的表（可能不推荐，因为人们可能会认为它们是 oracle 特殊表）。
if you're referring to objects owned by SYSand SYSTEMthen Oracle names its memory structure views for example V$(eg v$session). but these are just a naming convention that Oracle corp uses for its objects.
如果您指的是由拥有的对象SYS，SYSTEM然后 Oracle 将其命名为内存结构视图，例如V$（例如v$session）。但这些只是 Oracle 公司为其对象使用的命名约定。
回答by kiltek
Tables that contain the prefix V$are tables that store volatileinformation.
包含前缀V$的表是存储易失性信息的表。
Volatile informationis produced by an oracle instance while it is in use (In use means the instance is up and running). Volatile Information includes Statistics, session information of users, memory allocation.
易失性信息由 Oracle 实例在使用时产生（使用中意味着实例已启动并正在运行）。易失性信息包括统计信息、用户会话信息、内存分配。
回答by Frank Schmitt
Usually, these are tables that "belong" to the database - either because they are owned by one of the predefined users (SYS, ...) or because Oracle uses them for housekeeping, e.g. for
通常，这些是“属于”数据库的表 - 因为它们由预定义用户之一（SYS，...）拥有，或者因为 Oracle 将它们用于内务管理，例如
- fulltext indices (these are named DR$... )
- materialized view logs (these are named RUPD$... and MLOG$...)
- 全文索引（这些被命名为 DR$... ）
- 物化视图日志（这些被命名为 RUPD$... 和 MLOG$...）
But you can't rely on that rule, because (as DazzaL already mentioned), nothing prevents you from creating your own tables with a dollar sign in the name.
但是您不能依赖该规则，因为（正如 DazzaL 已经提到的），没有什么可以阻止您创建自己的名称中带有美元符号的表。
