Re: Where do I start

In message <43214346$0$677$edfadb0f_at_dread12.news.tele.dk>, "Steen Persson (DK)" <spe_at_REMOVEdatea.dk> writes
>Hi
>
>I'm a MS SQL Server DBA and I know next ot nothing about how Oracle works.
>Now I need to get involved in our Oracle server (some administration and
>querying databases) so where do I start? Can any of you point me to some
>good "Oracle Beginners guide" on how to do the basic stuff?
>I've installed the Oracle client and started to dig around to see how it
>looks, but it's not all very clear.

In the 10G Release 1 documentation front page on <http://tahiti.oracle.com>, there is a getting started section. Start with either the 2-Day DBA or the Concepts guide.

> What is the Oracle equivalent to MS SQL
>Server's Query Analyzer and

Depending on which components of the client you installed (and which version) you have the option of

sqlplus - command line sql tool, like isql but much more functional. Available on all platforms.
sqlplusw - windows version of above. Suprisingly, less usable than the command line version. Windows only.
sqlplus worksheet, part of enterprise manager and almost directly equivalent functionally to Query Analyzer.

>Books On Line?

The complete manual set for various versions is at <http://tahiti.oracle.com>.

Be aware that the two systems are very different under the covers and what works in one won't necessarily work in the other. Or if it works, it might not the best way to do it.

-- 
Jim Smith
Because of their persistent net abuse, I ignore mail from
these domains (among others) .yahoo.com .hotmail.com .kr .cn .tw
For an explanation see <http://www.jimsmith.demon.co.uk/spam>