compare user objects

[mike]

Whenever I have tried to use the compare user objects tool, an hour glass comes up and it hangs until I give up and stop it. I only have access to apps and I think (don't know for sure) it's gathering information on everything for the user.

Is there a way to filter what it's looking for, or is there a way to make it work, or am I using it wrong?

I am using pl/sql developer version 5.1.1.672 on Oracle 8i.

Thanks

 

[Marco Kalter]

The Compare User Objects tool will compare the objects you have selected (use Ctrl-click and Shift-click for multi-select). If you have not selected anything, everything will be compared.

When exactly does the hourglass come up? Immediately when you start the tool, or after selecting the objects and pressing the 'Compare' button?

------------------
Marco Kalter
Allround Automations

 

[mike]

Thanks for replying. The hourglass comes up as soon as I start the tool. I let it go yesterday and it ran for a long time until the PC ran out of memory. It never brings up the list of objects to select one.

I tried unselecting the "use DBA views" preference and it didn't help.

I'm using Windows 2000 Professional for the operating system with 512Mb RAM and there are 166k rows in the sys.all_objects table if that helps any.

 

[Marco Kalter]

How many rows are in the user_objects view?

------------------
Marco Kalter
Allround Automations

 

[mike]

There are 76,729 rows in user_objects.

Maybe a future enhancement would be to compare an object in the schema browser when it is right clicked if we can't filter the amount shown.

 

[Marco Kalter]

We will try to find an appropriate solution for this.

------------------
Marco Kalter
Allround Automations

 

[a_kassabian]

Is there any enhancement to this functionality? I had also posted in 2006...

Is there no way to set up a default object filter or to prevent the immediate querying of the schema?

Thanks,
Ara

 

[Marco van der Linden]

I think this has been suggested before, but it would be nice if we could apply a filter _before_ all objects are retrieved from the database. In day to day use I'd only like to compare one or two objects. Having to wait until all objects are retrieved before one's able to select the object of interest seems to me 'the other way around'.

 

[Marco Kalter]

We'll hopefully have a solution for this in the next release.