Toad Data Point 4.3, Oracle client 11G (R2):
My company has different connections based on what data needs to be accessed. (Separate regions will be restricted to certain connects (ie North, Southwest) to be able to access data from buildings in those areas. I was given read/write access to North but when i try running an UPDATE query it throws: Oracle Database Error: ORA-16000: database or pluggable database open for read-only access
I'm not sure of what steps need to be done to ensure an oracle connection in Toad data point has the proper setup to distinguish it as read/write instead of read only. Here is what I did (based on googling/toad install reference).
- Toad data point 4.3 is installed as typical install (not read only mode (it has the symbols below the table dropdown to create a table and others)
- Connections were added through ODBC data sources (both user dsn and system dsn) (I made sure to keep read only connection unchecked)
Is there anything i have to do (preferences wise) in Toad data point to fix this or is it more setup like ODBC. I'm at my wits end with this and would truly appreciate any help/pointers anyone could give.