The DG could not edit the views of Oracle in 2017.3

Hi, sorry.

There is no view editor of Oracle in the 2017.3.

 

I hint the F4 to run the view of Oracle. I could get the table of the data. But I click the DDL in the result table, the text shows:

-- auto-generated definition
-- No source text available

Please add the function to edit the DDL of the Oracle Views. Thanks.
And Please make the DataGrip more powerful on the Oracle.( Like the PL/SQL Developer )

Thanks.

 

6 comments
Comment actions Permalink

Hi,

Do you try to edit system view or custom one? 

Could you try to invoke "Forget cached schemas..." action and synchronize your datasource. After synchronization try to edit your view.

Thank you.

0
Comment actions Permalink

Thanks, but the "Forget cached schemas..." is not in the 2017.3.3. The database is huge and there many tables. I will try it with "Synchronize".

0
Comment actions Permalink

Hi,
One can find "Forget cached schemas..." in "Database Tools..."

 

Could you write us in case "synchronize" won't help you?

Thank you.

0
Comment actions Permalink

The same issue happened.

My DB is huge with 84 userids. And many many tables and views.

0
Comment actions Permalink

Thanks guys! You are kind. Very much!!!!!

0

Please sign in to leave a comment.