Enhancement Request: Longstanding issue with user object

[a_kassabian]

My group is working with Oracle E-Business Suite. There, the main schema (APPS) has over 180,000 objects. Trying to do anything with Export User Objects, Import User Objects, Compare User Objects, Compare Table Data, Export Tables is almost impossible because the first thing PL/SQL Developer does is to load the list of objects, which takes around 20 minutes. There is no way for a user to cancel this operation or add a filter.

This has been the case since PL/SQL Developer 6 or 7 (or whenever these menus were added). Please! Please! fix this. This would be a lot more useful to me than any improvements to the db scheduler interface.

Ara
Jet Propulsion Laboratory

 

[Marco Kalter]

This is on the to-do list for version 11.

 

[toshlan]

Was this addressed in version 11? If I enter a filter for name or type before choosing a User in the drop down, there is still a long delay and then it returns all the user's objects. Also, after selecting a couple of objects and clicking Compare, there is a several second delay before it seems to begin the comparison process.

 

[Marco Kalter]

Yes. These tools now start without a pre-selected schema. You now apply a filter and select a schema before the objects are fetched.