LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (http://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   What do I need to read data from Oracle Database? (http://www.linuxquestions.org/questions/linux-newbie-8/what-do-i-need-to-read-data-from-oracle-database-624896/)

eentonig 03-01-2008 02:33 AM

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.

Tinkster 03-01-2008 08: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 01:37 AM

Quote:

Originally Posted by eentonig (Post 3074611)
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 02:03 AM

Quote:

Originally Posted by yusufs (Post 3075352)
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 11: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.


All times are GMT -5. The time now is 09:31 PM.