Page 1 of 2
[Oracle] Database Navigator don't work
Posted:
Tue Mar 29, 2016 8:56 amby TheBlackReverand
Re: [Oracle] Database Navigator don't work
Posted:
Tue Mar 29, 2016 10:36 amby 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 pmby TheBlackReverand
Re: [Oracle] Database Navigator don't work
Posted:
Tue Mar 29, 2016 1:59 pmby 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 pmby TheBlackReverand
Re: [Oracle] Database Navigator don't work
Posted:
Tue Mar 29, 2016 2:46 pmby 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 amby TheBlackReverand
Re: [Oracle] Database Navigator don't work
Posted:
Tue Apr 12, 2016 9:24 amby 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 amby 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 amby TheBlackReverand