I just installed 6.2.4176 (in hopes that this would be fixed) but when I expand the Tables node, it hangs…forever. I’m connecting as my personal user and switching over to our app schema. I’ve never really waited long enough to see how long it takes ( I gave up after 15 mins) . The DBA says its trying to run the following SQL which I can run from a code editor just fine. I can’t figure out if this is a SQLNav issue or a permission issue. All I know is that it didn’t happen prior to v6.1
The funny thing is that this happens in our Q, U and prod envs not Dev. I’m having the dba take a look at the roles and grants etc. but that shouldn’t matter should it as long as I have select privs on sys.all_objects and sys.all_tables? Has anyone seen this problem?
Update: I installed Toad 18.104.22.168 and was able to retrieve the list of tables in seconds. SQL Navigator hangs forever. What is different about the way the two tools retrieve the list of tables?
SELECT ‘EDW_STG’ owner,
DECODE(a.status, ‘VALID’, 0, ‘INVALID’, 1, 2) status,
DECODE(b.partitioned, ‘YES’, ‘Y’, ‘NO’, ‘N’) partitioned,
DECODE(b.nested, ‘YES’, ‘Y’, ‘N’) NESTED,
DECODE(b.IOT_Type, ‘IOT’, 1, ‘IOT_OVERFLOW’, 2, 0) IOT_Type,
FROM sys.all_objects a, sys.all_tables b
WHERE b.owner = ‘EDW_STG’ --:schema
AND a.owner = ‘EDW_STG’ --:schema
AND a.object_name = b.table_name
AND a.object_type = ‘TABLE’
AND b.dropped = ‘NO’
Message was edited by: jstinnett