Community
Participate
Working Groups
Build Identifier: 20110916-0149 We have very large Oracle Databases we have to work with, thousands of schemas in each database. When using the Data Source Explorer, I create a connection to my desired DB, then click into Database Connections -> Desired DB (Connect) and from there I expand Schemas. It takes approx 4 minutes to populate. This is expected as it seems to always query the DB for all available schemas. Would like to ability to explicitly select a set of schemas to show, and when using that type of filter, only have the DTP component query for those explicity defined schemas. This would probably be helpful to anyone working with databases housing more than a few hundred schemas. Reproducible: Always Steps to Reproduce: 1. Connect to a database with hundreds or thousands of schemas. 2. Expand the Data Source Explorer : Database Connections - Desired DB - Desired SID - Schemas element. 3. Wait...
So you're looking for some ways to filter the search a bit so it pulls back a subset of the schemas as opposed to all schemas? I think you can do this now by applying filters to the root schema node and selecting "Properties" and then specifying an expression or selecting particular schemas in the list. That said, I'm not sure that this will aid in reducing your 4 minute (ouch!) query time by much if any. Can you give it a shot to see if it helps at all? Also, can you tell us whether you're using the default Oracle support in DTP or are using the Oracle-provided DTP plug-ins? (The Oracle plug-ins are available here: http://www.oracle.com/technetwork/developer-tools/eclipse/overview/index.html and may be a bit more optimized for your needs.)
