Hello,

Is there a good book you can recommend that exhaustively covers most
everything you would need to do to as a DBA using Oracle 8\9 using
SQLPlus (i.e. no GUI)?

In short, I need to become an Oracle SQLPlus command line guru
yesterday. I have only used the GUI tools to this point. I have very
little experience with: ALTER DATABASE x, ALTER TABLE x etc. etc. etc.

TIA,

Michael

Michael wrote:

> Hello,
>
> Is there a good book you can recommend that exhaustively covers most
> everything you would need to do to as a DBA using Oracle 8\9 using
> SQLPlus (i.e. no GUI)?
>
> In short, I need to become an Oracle SQLPlus command line guru
> yesterday. I have only used the GUI tools to this point. I have very
> little experience with: ALTER DATABASE x, ALTER TABLE x etc. etc. etc.
>
> TIA,
>
> Michael

Enjoy!

http://otn.oracle.com/pls/db92/db92....emark=homepage

http://download-west.oracle.com/docs...a96540/toc.htm

Michael wrote:

>
> Is there a good book you can recommend that exhaustively covers most
> everything you would need to do to as a DBA using Oracle 8\9 using
> SQLPlus (i.e. no GUI)?
>
> In short, I need to become an Oracle SQLPlus command line guru
> yesterday. I have only used the GUI tools to this point. I have very
> little experience with: ALTER DATABASE x, ALTER TABLE x etc. etc. etc.
>
> TIA,
>
> Michael

If your GUI is the Oracle Enterprise Manager, click 'SHOW SQL' on any screen
to display the command line the OEM will invoke.

All syntax is in SQL Reference manual. Mastering them is in ORacle Concepts
and Oracle Database Administration Guide or Oracle Application Developers
Guide. These are available at htp://docs.oracle.com

You may also wish to learn about the functionality of the actual
SQL*Plus tool as well:

Oracle manual: SQL*Plus Users Guide and Reference

or:

SQL*Plus: The Definitive Guide from Oreilly-

http://www.oreilly.com/catalog/orsqplus/

melliott42@yahoo.com (Michael) wrote in message news:<91721cf.0406301630.7d885ec9@posting.google.c om>...
> Hello,
>
> Is there a good book you can recommend that exhaustively covers most
> everything you would need to do to as a DBA using Oracle 8\9 using
> SQLPlus (i.e. no GUI)?
>
> In short, I need to become an Oracle SQLPlus command line guru
> yesterday. I have only used the GUI tools to this point. I have very
> little experience with: ALTER DATABASE x, ALTER TABLE x etc. etc. etc.

The Oracle Press 9i DBA Handbook isn't so bad. Between that, the
concepts manual and the sql guides and trying things and googling
here, you can get through all sorts of learning experiences. The most
important thing is to set yourself up a test instance and start doing.

Check out Lawson's book, and the dizwell.com new features paper, too.
Ault has a book of scripts, but I haven't looked at it.

Connor McDonald, Cary Milsap and Tom Kyte all have excellent books
too, depending on what you mean by command line guru. Some would
argue that being a DBA these days means being able to work with stored
procedures and PL/SQL and such.

jg
--
@home.com is bogus.
http://www.automobilemag.com/feature...errarifactory/