Which Tool ? :-o
488972May 9 2007 — edited May 11 2007I would like to ask the Guru's a question. I've been working on Oracle a couple of months now (coming from another DB). I picked up various tools from various people, eg.
- sqlplus (server & client), sqldeveloper, toad, enterprise manager (stand alone & web client), etc.
Which tool do most people use for database administration ? At the moment I find this a little confusing - there are too many tools to use. For example, when I need to kill sessions, I choose between the 2 EM clients. When I need database info, I can use any of the above tools.
Another task I often do, is dropping & recreating existing database objects. To do that I need to generate the sql code for the object first. This can be done using sqlplus, and generating the code, but then you need the correct query. Sqldeveloper also gives me this option, but not for all database objects (lacking in certain areas).
It would be good if I could use only one tool for database administration tasks (or at least to generate the DDL for me).