PL / SQL developer will not run read queries against a linked read-only database
I just installed PL / SQL Developer (version 10.0.5.1710) and my second query is:
SELECT * FROM MySchema.MyTable@DBRead
This is discarded with:
ORA-16000: database open for read-only access
ORA-02063: preceding line from DBRead
The database is indeed read-only, which is fine; I rarely need to update anything on this system.
What do I need to configure in PL / SQL Developer to find out what I'm just trying to read?
The same query with the same connection information works fine in SQL Developer or TOAD.
+3
user565869
source
to share
1 answer
I am assuming a PL / SQL developer is working in the background SELECT * ... FOR UPDATE;
to make your grid editable. You probably need to remove some of the checkboxes in the settings related to "editing in grid" or "locking selected rows". Try to disable settings-> connection-> allow edit database source
+2
source to share