Re: Need help with tools

On Mar 23, 5:23 pm, DA Morgan <damor..._at_psoug.org> wrote:
> efair wrote:
> > Hi,
>
> > I've been living in the MS SQL Server world for some time -- both
> > developing and supporting databases. I now have to start supporting
> > Oracle9i, and I know very little about it beyond sqlplus.
>
> > MS includes a few tools that I use daily -- Enterprise Manager and
> > Query Analyser -- and I'm wondering if there are equivalent tools in
> > Oracle.
>
> > Enterprise manager is a graphical tool for showing the details of
> > database(s) -- table names, column names, primary keys, constraints,
> > indexes, and the like.
>
> > Query manager is a graphical tool for running SQL queries. It allows
> > multiple windows to be open -- so that you can connect to two
> > databases and run two queries against each database and keep the
> > result sets in separate windows. It also supports a "grid output"
> > mode that allows results to be viewed by scrolling up and down, and
> > allows copy and paste into spreadsheets.
>
> > Are there any similar tools included with Oracle9i?
>
> > Are there any good books for people in my situation?
>
> > ed
>
> I wouldn't suggest starting with tools ... but rather with the concept
> docs athttp://tahiti.oracle.comand a copy of Tom Kyte's latest books.
> Tom does an extremely good job of helping people understand the deltas.
>
> Also run the following demo:http://www.psoug.org/reference/mvcc.html
>
> I would suggest not touching any part of Oracle until you understand
> how and why it works.
>
> Best wishes.
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text -
>
> - Show quoted text -

If you are a developer rather than a DBA you can start with the Application Developers Guide - Fundamentals instead of Concepts, but you should go back and review the Concepts Guide after reading the Developers Guide.

If you are a DBA follow Concepts with the DBA Administrators Guide and the Backup and Recovery manuals.

Daniel's reference site provides access to a fair number of useful articles and scripts. Another good site is the cooperative FAQ (find via seach) that Jonathan Lewis hosts plus you have Jonathan's materials there also.

HTH -- Mark D Powell -- Received on Fri Mar 23 2007 - 20:08:17 CDT