CR XI SP 3

[byteias]

CR XI with Oracle 9i and Microsoft OLE DB for Oracle.
I connected to a new instance that has more than 2500 views, since my view name (xcr_..) starts with an X will show up at the end of the list therefore I cannot see it, because the limitation of OLE DB (ADO). Is ther a way to expand the number of views to be shown at the available datasources?
My CR option is set up for Table, Views and Proc's
Thanks,
Ivan.

 

[lbass]

If you go to file->options->database->data explorer, I think you could use the 'table name like' feature to limit the list that is displayed (although I've never used this feature).

-LB

 

[byteias]

We have over 25000 views not 2500 as I mentioned before.
It workes when I used views like...
Thank Ibass for your help.
Ivan.