Do you see the sequences if connected using legacy introspector by the same user? Please try to un-check this option, click Forget schemas in the schema context menu and invoke Synchronize action again.
Legacy introspection option means that for retrieving information from the database DataGrip uses only jdbc driver implementation. The last versions of DataGrip have more advance introspection of Oracle types so it should work better (faster and more precise).
If problem remains, please post output of Test Connection report for Oracle data source and idea.log after invoking Synchronize action (without legacy introspector).
I solved it by selecting the option "Use legacy introspector".
But what that means about the DB config?
Hello,
I see sequences in the Database tool window:
Do you see the sequences if connected using legacy introspector by the same user? Please try to un-check this option, click Forget schemas in the schema context menu and invoke Synchronize action again.
Legacy introspection option means that for retrieving information from the database DataGrip uses only jdbc driver implementation. The last versions of DataGrip have more advance introspection of Oracle types so it should work better (faster and more precise).
If problem remains, please post output of Test Connection report for Oracle data source and idea.log after invoking Synchronize action (without legacy introspector).
Just did what you said and it worked.
Thank you, Andrey.