oracle 如何过滤 sql developer 以仅显示我的表？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/21496073/
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
How to filter sql developer to only show my tables?
提问by iAteABug_And_iLiked_it
Coming from sqlserver world, I am a noob in the oracle/sql developer world. In the SQL Developer , I only want to show the tables I created, but it is showing tons of extra tables which I don't need and i have to keep scrolling. The JOB table in the screenshot below is the only one that I want to see.
来自 sqlserver 世界，我是 oracle/sql 开发人员世界的菜鸟。在 SQL Developer 中，我只想显示我创建的表，但它显示了大量我不需要的额外表，我必须继续滚动。下面屏幕截图中的 JOB 表是我唯一想看到的。
I tried creating a filter, ( a LIKE ) filter by right clicking the tables and choosing CREATE FILTER but I have tried many combinations of filters in that dialog box and I can't get just my JOB table to show and others ( I think all of the extra ones have a $ and _ in the name) to go away.
我尝试通过右键单击表并选择 CREATE FILTER 来创建过滤器（一个 LIKE 过滤器），但我在该对话框中尝试了多种过滤器组合，但我无法只显示我的 JOB 表和其他表（我认为所有额外的名称中有 $ 和 _) 消失。
How do I filter them? Thanks
我如何过滤它们？谢谢
回答by Jeff
The answer about not creating tables as a system user is correct. In the meantime, you can filter out these tables with settings like these:
关于不以系统用户身份创建表的答案是正确的。同时，您可以使用以下设置过滤掉这些表：
For easy copy pasting, here's the list:
为了方便复制粘贴，这里是列表：
AQ$%DEF$%LOGMNR%LOGSTD%MVIEW%REPCAT%OL$%
AQ$%DEF$%LOGMNR%LOGSTD%MVIEW%REPCAT%OL$%
回答by Jeffrey Kemp
It looks like you're logged in as a system user - you shouldn't be creating your tables in there.
看起来您以系统用户身份登录 - 您不应该在那里创建表。
You should create a separate user (it will have its own schema) and you'll only see the tables you create.
您应该创建一个单独的用户（它将拥有自己的架构）并且您只能看到您创建的表。
回答by Dattatray Thorat
It seems like you have logged in as a SYS user. If you dot want to see the system tables, then apply simple filter like below
您似乎以 SYS 用户身份登录。如果您想查看系统表，请应用如下所示的简单过滤器
Name -> NOT LIKE -> %$%
姓名 -> 不喜欢 -> %$%
All table with $ in it will be filtered out.
所有包含 $ 的表都将被过滤掉。
回答by Vignesh Kumar A
I think It's not possible. But you can query your table through your own SCHEMA
我认为这是不可能的。但是您可以通过您自己的SCHEMA查询您的表
Like this
像这样
SELECT DISTINCT OWNER, OBJECT_NAME
FROM ALL_OBJECTS
WHERE OBJECT_TYPE = 'TABLE'
AND OWNER = '[some other schema]'
(OR)
（或者）
SELECT TABLE_NAME
FROM ALL_TABLES
WHERE OWNER='OTHER-SCHEMA'
