ORACLE connection as sysdba: selecting an additional Schema doesn't show its content (e.g. tables)
Hi,
when I select an additional schema via "more schemas..." from an ORACLE connection, the schema is shown in the database window, but ther is no content:
I'm using a connection to a local ORACLE instance as "sys as sysdba". Synchronising does not help.
Is this a bug?
My DataGrip Version is 2016.3.3
My current Workaround is to add separate DB Connections for each schema.
Best Regards
Stephan Fabrizek
Please sign in to leave a comment.
Hi,
Could you try DataGrip 2017.1 EAP to reproduce the problem?
Thank you.
Hi,
the EAP Version makes it a little better. By synchronizing it now lists all routines, other elements such as tables or sequences are still missing.
When openening a new cosole for the schema it states the correct schema in the the top right corner (???_CAT_DEV), but when executing a query the result window shows the results for the other schema (???_CAT_DEV_ANTI).
Best regards
Stephan
Hi,
Could you provide full schema name? Are there any special chars?
As a workaround try to invoke Forget Schemas action on data source context menu.
Also, it would be helpful if you provide some IDE logs.
Thank you.
Hi Vasily,
forget schemas did the trick.
Except _ ther were no special chars within the schema name.
Thank you