What do I need to read data from Oracle Database?

eentonig · 03-01-2008, 01:33 AM

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.

Tinkster · 03-01-2008, 07:13 PM

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

yusufs · 03-02-2008, 12:37 AM

Quote:

Originally Posted by eentonig

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.

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

eentonig · 03-02-2008, 01:03 AM

Quote:

Originally Posted by yusufs

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?

Robert0380 · 03-05-2008, 10:03 AM

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.