Re: DBA/Programmer GUI tool for Oracle in Linux

>So, I am wondering what are some of the tool that you use for doing simple
>admin and programming tool. Nothing fancy, just probably a gui tool that can
>do Add/Remove user + password, create/drop table/column, alter table/column,
>and inserting data into table.

All the things you mention here except for data insertion are best done from sqlplus. It takes less time to type the command than to point and click.

For GUI stuff (ie, pretty pictures for session stats) and add hoc query, I use Tora daily. It has some quirks, but it is the best package for linux I've found.

Then again, YMMV and to each his own...

Ron Thomas
Hypercom, Inc
rthomas_at_hypercom.com
Each new user of a new system uncovers a new class of bugs. -- Kernighan

                                                                                                                                                   
                      techlist_at_voyager.p                                                                                                           
                      hys.utk.edu               To:       ORACLE-L_at_fatcity.com                                                                     
                      Sent by:                  cc:                                                                                                
                      ml-errors_at_fatcity.        Subject:  DBA/Programmer GUI tool for Oracle in Linux                                              
                      com                                                                                                                          
                                                                                                                                                   
                                                                                                                                                   
                      07/19/2003 09:54                                                                                                             
                      AM                                                                                                                           
                      Please respond to                                                                                                            
                      ORACLE-L                                                                                                                     
                                                                                                                                                   
                                                                                                                                                   

Hello,

I am rather new on using oracle in linux. I have some more experience with just programming web application with oracle as the backend database, but not so much with the administration of it.

So, I am wondering what are some of the tool that you use for doing simple admin and programming tool. Nothing fancy, just probably a gui tool that can do Add/Remove user + password, create/drop table/column, alter table/column, and inserting data into table.

I've seen TOAD before, but never really used it. But I think it's only run in MS Windows. So something similar to TOAD that runs in linux would be sufficient. I've tried TOra, it can do more stuff than I can understand right now, but it lacks basic things like dropping and creating table, altering table, etc.

Any info will be greatly appreciated.

Thanks in Advance
Reuben D. Budiardja

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Reuben D. Budiardja
  INET: techlist_at_voyager.phys.utk.edu

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).