Recent content by webdba

More poking around.... I added the filter: owner 'XDB' to the Browser window and all problems with hanging up went away for Tables, Views, Procedures.

I just did a bit more poking around and found that it definitly relates to the priv's on a schema. It seems to throw out a boat anchor when it hits the XDB schema in our 10g installation. If I alter the suggested query and then exclude the XDB schema everything works just fine. Here was the...

I am having the same problem against a 10g DB. I can run the suggested query from SQL*PLUS with no problems. If I run the query without the "where" and "order by" clause it works fine. If I run the query with the where clause it runs fine for about 600 records and then hangs and if I break...