How to filter sql developer to only show my tables?

Question

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.

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.

How do I filter them? Thanks

Answer 1

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$%

Answer 2

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.