'dbeaver table editing is blocked, what should I do?
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 |
