How-to Fix Auto-Complete for Oracle?
When I connect to my companies SQL Server database, there's an expand (plus?) button that easily allows me to see all of the other tables -- and auto-complete works like a dream.
When connected to our Oracle database, base commands show up in auto-complete, but none of the schemas / tables. Is there an advanced option I need to set?
Thanks!
Edit: I've checked the schemas I use in, "Schemas & Tables" under the Data sources editor -- still nothing :-(
Please sign in to leave a comment.
Looks like it's an issue with database metadata loading. Please fill a new issue (http://youtrack.jetbrains.com/issues/DBE#newissue=yes) and provide some additinal information for reproducing.
Thank you, Sergey.
http://youtrack.jetbrains.com/issue/DBE-387
Select "synchronize" from datasource pop-up menu.
%200xDBE-138.551.png)
I also encountered this problem. In my case the scheme was not checked. For this: right click on connection -> database tools -> manage schemas.
There you check the scheme which has your tables you want to be auto completed.