Page 1 of 1

Oracle JDBC Connection in Read only mode

Posted: Mon Mar 14, 2011 4:36 pm
by RikardSvenningsen
Hi
Is there any way to put the: oracle.jdbc.driver.OracleDriver into read-Only mode.
I have a prebuild Oracle BASE with more than 100 table with lots of relation between tables, when I open the connection and check the relation, i can see a overwhelming numbers of relation.
My problem is that I only need to table and when I hide all other tables, then I can't see any relation on this tables.
As for now I am not in Read-Only mode so putting relation in between the tables could break the database or what?
I hope for a way to open the connection in read-only..

Re: Oracle JDBC Connection in Read only mode

Posted: Tue Mar 15, 2011 7:59 am
by DACM
There is a read-only connection setting, and it may be worth a try, but folks on the internet say it doesn't work as advertised/expected.
So, my first inclination would be to setup a "read-only user" (perhaps on the schema that contains all your tables) and connect as that user. But a quick search of the internet reveals that there's no easy way to do this in Oracle. But it can be done. I would start by reading this article:
http://decipherinfosys.wordpress.com/20 ... in-oracle/

(Closed as not solve) Oracle JDBC Connection in Read only mo

Posted: Fri Mar 18, 2011 11:06 am
by RikardSvenningsen
I am to scared to try the JDBC suggestions.
I will move on doing it from ODBC.
Have done that from MS Office with Access before, now I will be doing it from OpenOffice instead.
If I can't get that into work I will make a comment her...