Page 1 of 2
[Oracle] Database Navigator don't work

Posted:
Tue Mar 29, 2016 8:56 am
by TheBlackReverand
Re: [Oracle] Database Navigator don't work

Posted:
Tue Mar 29, 2016 10:36 am
by Serge
What is your Oracle server version?
DBeaver uses query "SELECT U.* FROM SYS.ALL_USERS U WHERE (U.USERNAME IN (SELECT DISTINCT OWNER FROM SYS.ALL_OBJECTS))" to read schema list. Does this query return any results in your case?
You can enable metadata logging in query manager (Preferences->Database->Query Manager, enable all object types and query types). And then check how many rows each metadata query returns.
Re: [Oracle] Database Navigator don't work

Posted:
Tue Mar 29, 2016 12:13 pm
by TheBlackReverand
Re: [Oracle] Database Navigator don't work

Posted:
Tue Mar 29, 2016 1:59 pm
by Serge
Looks like schema name is empty (this problem actually caused the error in
viewtopic.php?t=2908).
Schema name is USERNAME column from "SELECT U.* FROM SYS.ALL_USERS U" query. It can't be empty, as far as I know..
Re: [Oracle] Database Navigator don't work

Posted:
Tue Mar 29, 2016 2:37 pm
by TheBlackReverand
Re: [Oracle] Database Navigator don't work

Posted:
Tue Mar 29, 2016 2:46 pm
by Serge
Well, I found a bug in current schema detection. It is fixed and committed (will be included in 3.6.4).
What about the rest 3 schemas - can you see tables there?
Re: [Oracle] Database Navigator don't work

Posted:
Wed Mar 30, 2016 7:12 am
by TheBlackReverand
Re: [Oracle] Database Navigator don't work

Posted:
Tue Apr 12, 2016 9:24 am
by TheBlackReverand
Hello,
I just test the 3.6.4 and don't work...
No error but I don't have Schema name and no tables list
You can see this in attachments
Thanks
Re: [Oracle] Database Navigator don't work

Posted:
Tue Apr 12, 2016 9:34 am
by Serge
Weird.
And still nothing in the Error Log view?
Maybe something interesting is in debug-log? (
https://github.com/serge-rider/dbeaver/wiki/Log-files)
Re: [Oracle] Database Navigator don't work

Posted:
Tue Apr 12, 2016 9:57 am
by TheBlackReverand