[jbosstools-issues] [JBoss JIRA] Commented: (JBIDE-4426) Filtering Oracle's bogus $BIN tables

[Krasimir Goutcev (JIRA)]

    [ https://jira.jboss.org/jira/browse/JBIDE-4426?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12473734#action_12473734 ] 

Krasimir Goutcev commented on JBIDE-4426:
-----------------------------------------

Hi Vitali,
I suppose you reтrieve tables with something like this:
SELECT
    *
FROM
    user_objects
WHERE object_type ='TABLE' ;

if this is true, then correct is:

SELECT
    *
FROM
    user_objects
WHERE
    object_name NOT LIKE 'BIN$%'
AND object_type ='TABLE';

Regards.

> Filtering Oracle's bogus $BIN tables
> ------------------------------------
>
>                 Key: JBIDE-4426
>                 URL: https://jira.jboss.org/jira/browse/JBIDE-4426
>             Project: Tools (JBoss Tools)
>          Issue Type: Bug
>          Components: Hibernate
>    Affects Versions: 3.1.0.M1
>         Environment: Galileo RC2
> JBTools H235
> DB Oracle 10.2.0.1.0 
>            Reporter: Krasimir Goutcev
>            Assignee: Vitali Yemialyanchyk
>             Fix For: 3.1.0.M3
>
>         Attachments: 2009-06-04_1050.png
>
>


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira