Re: Need Recomendations for good Oracle 9i books

michaelloll_at_hotmail.com said...
> Anyone have good recs for books on 9i? I am coming from a SQL Server
> 2000 background. I understand database design, but I need a book on
> Oracle such as:
>
> -How everything is organized (schemas, tables, procedures, etc)
> -Basic tasks such as creating users, roles, tables
> -Backup and restore
>
> I am confident I can design the tables, relations, views, stored
> procedures, choose indexes, etc - I am doing that now. Unfortunately,
> I do not know how to do things like performance testing,
> backup/restore, etc.
>
> SQL Server is so much simpler in terms of how things are stored that
> it made a little more sense to me, but I really want to learn Oracle
> 9i for this project, and I've been tasked with it along side our other
> DBA. Unfortunately, apparently he just learned 9i through osmosis
> because he has no good books to recommend.
>
> Any advice?
>
> Also, a good concise book on PL/SQL programming would be nice. So I
> guess I am looking for two books...
>
>
> --
> Mike Loll
>

I haven't seen any "Oracle for Sql Server Users" (though a book like that might sell).

There are a series of Oracle 101 books (red covers with yellow lettering) that contain basic stuff about the book's title. For an introduction, they're quite good. But they are basic ... so if you want to move beyond that, they might leave you with more questions than answers.

A step up from there are the Wrox and O'Reilly books. One really good book that will carry you thru to the expert level is Tom Kyte's Oracle Expert One-On-One book.

Buying Oracle books can get a bit expensive, however. If you have a bookstore nearby, your best bet would be to leaf thru a few books to see if they're at the level you're looking for.

-- 
/Karsten
DBA > retired > DBA