#244 Hide Oracle Bin$.....==$0 tables with filter

General
closed
5
2007-07-19
2007-06-12
Anonymous
No

With Oracle, a number of internal data are exposed as tables with a name that starts with "BIN$" and ends with "==$0". These accumulate over time, and after a few months of work these non-table (and completely uninteresting) "tables" easily outnumber the real tables 10-to-1. Notice the position of the scrollbar in the attached screen dump.

There should be a way to hide these BIN$-tables.

One way is to have the Oracle plugin interact with the core to make it "undisplay" these tables.

Another approach could be to add a show/hide option for pattern based filtering of resources in the catalog. Using filters to display ONLY the BIN$-tables is easy, but that is the opposite of what I want: The filter contains the prefix of tables I want to hide, not the tables I want to see.

The Oracle BIN$-table problem exist with other SQL tools in Java I've tried as well.

Discussion

  • Rob Manning

    Rob Manning - 2007-06-12

    Logged In: YES
    user_id=1287991
    Originator: NO

    You could also do this right now:

    PURGE RECYCLEBIN;

    ALTER SESSION SET RECYCLEBIN=OFF;

    And then refresh the object tree. No more BIN$-tables?

    I believe the session scripts plugin will allow you to configure it to execute these commands when the session is started. I don't know much more about it than that.

    Rob

     
  • Rob Manning

    Rob Manning - 2007-07-19

    Logged In: YES
    user_id=1287991
    Originator: NO

    In CVS. Try it in the next snapshot. The default is to hide the tables and this can be disabled in Global Preferences -> Oracle -> Remove Recycle Bin Tables from Object Tree

    Rob

     
  • Rob Manning

    Rob Manning - 2007-07-19
    • labels: 381585 --> Oracle Plugin
    • assigned_to: nobody --> manningr
    • status: open --> closed
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks