HomeActive Query BuilderOracle 10.2g how limit the tables loaded into the metadatacontainer

Oracle 10.2g how limit the tables loaded into the metadatacontainer


Hi all,

First of all ActiveQuery is great :-)

I have an issue regardig only loading some of the tables related to a giver schema.
For example I have a schema named DMDBA wich has over 300 tables but I'm only interested in a few tables that matches 6 differnt filters.

Oracle constanly returns all PUBLIC objects along with other objects from BI CTXSYS and so on. I have tried many different metadatafilters but none successfully.

It works just fine on MSSQL.. :-)


How can I sepcify a filter that works on Oracle?
(and maybe get better loading performace)

I'm using the AcriveX version 1.10.5.7

Any help is most apreciated .

Best regards Steen jakobsen
Steen jakobsen | email
March 26 2009, 07:24 AM
IMetadataFilterItem mfi = queryBuilder1.MetadataFilter.Add;
mfi.Exclude = false;
mfi.ObjectMask = 'myobj1%';

mfi = queryBuilder1.MetadataFilter.Add;
mfi.Exclude = false;
mfi.ObjectMask = 'myobj2%';

//...

mfi = queryBuilder1.MetadataFilter.Add;
mfi.Exclude = false;
mfi.ObjectMask = 'myobj6%';

This filter should select objects names starting with "myobj1", "myobj2", ..., "myobj6".

Sergey Smagin | email
5 hours, 52 mins since original post
Hi Sergey,

This is exactely how I have done it. It works fine on MSSQL but unfortuantely not on oracle 10g. Also the schema fileter does not work on oracle. It sems to be some strage bug since when the filters are applied they does actually filter out some objects but it does it comnpletely wrong. any clue?

Regards Steen
Steen Jakobsen | email
18 hours, 11 mins since original post
.. It also works just fine on Sybase SQLAnywhere 10.01 :-) But still not on oracle


Regards Steen
Steen Jakobsen | email
18 hours, 15 mins since original post
Dear Steen,

The bug is fixed. Please download the updated build.
Sergey Smagin | email
1 day, 21 hours since original post
Hi Sergey,

I have downloaded version 1.11.9
However the problem is still the same.
It takes a long time to load and the objects are still not the right ones..
One odd thing is that i filteres out ALL objects related to the schema from where the desired objects were to loaded. Also it filteres out a lot of other object taht do not at all match the filters.
Hope this helps :-)

Best regards Steen


Steen Jakobsen | email
3 days, 19 hours since original post
Dear Steen,

the version 1.11.9 still has a problems with filtering Oracle aliases, all other object types works fine. Problem with aliases is fixed in 1.11.10, please download the updated build.

Please also note:
1) characters in filters are case-sensitive (because LIKE operator used to filter objects is case-sensitive)
2) filter must be filled BEFORE metadata loading (the best place is before Connect call)
Vitaly | email
4 days, 20 hours since original post
Hi Sergey,

Brilliant .. I have just downloaded the new version and it works just great.
Thank a lot for responding so quickly and for giving me the UPPECASE TIP ;-)

Best regards Steen

p.s. I use Oracel Instant Client 10.2g via MS OLEDB and it just works great without ANY Oracle net installation :-)
Steen Jakobsen | email
5 days since original post
Steen,

Can you tell me how you are using the Oracle Instant Client and are you having any speed issues? I am also having the same issues as you and need to download the latest Active Query built. I'm trying to built a very basic app similar to TOAD and but the hoop that are needed for an Oracle connection are confusing.
Thanks
Bill | email
3 months, 3 weeks since original post
This topic is closed