I have installed Oracle server on Linux and want to access Oracle (through Oracle prompt) on a different machine on a network without installing client. How could I do this?
There are only three ways I know of to access an Oracle database without installing Oracle client on the workstation. One, access the database through a Java program using JDBC drivers. The JDBC driver is one .jar file which needs to be on your workstation. Two, use generic ODBC drivers. This option normally has many problems so I really do not recommend it. Three, install iSQL*Plus on your database server, which is a Web-based version of SQL*Plus. Your client can point thier Web browser to iSQL*Plus and access the database.
Dig Deeper on Oracle database design and architecture
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.