What do I need to read data from Oracle Database?
 

Hi,

at work, we have a huge Oracle database which holds information regarding systems I need to manage. However, the webinterface/application that's used to access this data is very slow and limited.

So I would like to use a script to collect some information and store this in a csv file to run some scripts against it.

But what program do I need to install to access the Oracle Database?

I have the servername, port, user & pass, db name, ... I just don't know how to connect to it from my linux machine.

Oracle Instant client (freely downloadable) gives you SQL*Plus, which should do
what you're asking for just fine (provided you're familiar with the database
you're trying to query).


Cheers,
Tink

Hai,

You can always use oracle products to do such activities.. I suggest you to use TOAD.. from where u can just tranfser the datas to any format file like .csv,.xml,xls,txt..


Let me know if you need any help

Thanks
Yusuf

If I go to the TOAD site and download, I get a zip with an .exe file? Isn't there a linux client?

TOAD is actually a Qwest product (a really good one). You should install the Oracle client unless you're planning on using JDBC or similar to connect to the database. The client is a free download from Oracle but installation isn't 100% straight forward if you haven't done it before but it's easier than installing the full blown RDBMS.