'dbeaver table editing is blocked, what should I do?

image

You cannot edit the data in the table.

Field names are marked as locked.

How do I solve this?

DB : ORACLE



Solution 1:[1]

try to refresh the database connection. It worked for me, I couldn't insert rows after creating the table.

Solution 2:[2]

Never used dbeaver myself... after a little googling found this forum

post: https://dbeaver.io/forum/viewtopic.php?f=2&t=621

Though, this is an old post it mentions that:

DBeaver can edit table only if it has at least one unique key or index

and also

regarding oracle pseudo columns like rowid

for now DBeaver doesn't support "hidden" pseudocolumn at all

So, could you check if you can edit tables with unique key?

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 ejaenv
Solution 2 PKey