How to filter objects in Export User Objects?

[Luis]

Hi there,

I am using PL/SQL Developer 8.0.4 against a schema with hundreds or maybe even thousands of objects (tables, views, packages etc).

I created a filter in the navigator so I only see the objects I am interested on (just a couple dozen) which works perfectly. However when I select Export User Objects the whole list of objects is displayed and it takes me forever to pick the few objects I want to export.

Is there a way / workaround / trick to apply a filter to the Export User Objects list? (Personally, I would like it to respect the filter currently applied to the navigator)

As a side suggestion, I find the selection method in that window a bit clunky... It works OK for a small list, but when you have to browse through pages and pages of objects to select just a few, it is quite easy to click on the wrong spot (or without holding the CTRL key) and lose all your selection, forcing you to start all over again! (I may have some coordination problem but this keeps happening to me...

Thanks
Luis

 

[Marco Kalter]

You can filter the objects by double-clicking on a header and entering a filter expression. Furthermore you can right-click on the object list and use the Save Object Filter and Load Object Filter functions.

 

[Luis]

Hi Marco,

Thanks, that helps a lot!

However I am still having a problem... Believe it or not, the schema I connect to has 100k+ objects! The options you mentioned (correct me if I am wrong) are only available after the object list is loaded, which in my case takes a little less than forever... Is there a way to set a "default" filter that is applied automatically? (that is why I said that I would like the list to respect the current filter in the navigator by default)

In addition, while the object list is being loaded, PL/SQL Developer blocks and the screen goes blank being not possible to tell whether it is actually doing something or has frozen. It would be much better if there was some kind of visual clue to indicate it is doing something.

Thanks
Luis

 

[Luis]

Just an update: after my massive object list was loaded, I applied the filter as suggested but it took forever and I had to kill PL/SQL Developer in the end (after ~ 20min waiting)... it is unusable in my case unfortunately

I know that this is not a very common scenario, but I don't think it is so rare either. The reason we have so many objects is that we use Oracle EBS here, which is a quite well used ERP package, so this problem may affect other users too...

Thanks
Luis

 

[Luis]

Hi,

No comments on the points I raised above? Don't you think some improvements could be done? I am still unable to filter the objects I need to export and I have to select one by one from a list of dozens of thousands...

Another issue I noticed with the functionality to filter objects in the Export User Objects screen is this: if you filter the objects and click Export without selecting any object, ALL objects in the schema are exported, not only the objects that have been filtered.

(obviously I tried this in a different schema with much fewer objects...)

I don't know whether this is the way it is supposed to be, or whether it is a known issue, but it seems not very intuitive to me. It would be better if it exported only the filtered objects in this case.

Thanks,
Luis

 

[Marco Kalter]

There are too many objects, so we'll have to add a mechanism to filter the objects before they are added to the list. I have added this to the list of enhancement requests.