Re: Hide Oracle BIN$ objects

On 7/3/07, Erwan DUROSELLE <erwan_duroselle@xxxxxxxxxxx> wrote:
>
>
> Hi,
>
> Is there a way to configure SQuirreL (or the Oracle plugin) hide Oracle's
> Recycle bin's objects, whose name are like BIN$.
> They have a limited use, but are always visible and a bit polluting the tree
> view, IMHO.

Not at the moment.  But you can periodically execute:

purge recyclebin;

The sessions scripts plugin will allow you to execute this once
automatically each time you connect.

Additionally, if your tables all have the same prefix or suffix, you
can setup an object filter by right-clicking the root node in the
object tree and choosing "Edit Object Filter".  Unfortunately, it
doesn't support negation so you can't say NOT(BIN$) or some such
equivalent construct.

Rob

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/