Re: Oracle newbie

Norman Dunbar wrote:

> Aaron,
>
> once you've digested the concepts guide as advised by Sybrand, follow it
> up with Tom Kyte's excellent 'Expert one-on-one Oracle'. This book
> starts off by describing in detail the differences between SQL Server
> and Oracle - what makes one better or not, how things MUST be done
> differently and why.
>
> Good luck.
>
> Cheers,
> Norman.
>
> -------------------------------------
> Norman Dunbar
> Database/Unix administrator
> Lynx Financial Systems Ltd.
> mailto:Norman.Dunbar_at_LFS.co.uk
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------
>
> -----Original Message-----
> From: Sybrand Bakker [mailto:gooiditweg_at_sybrandb.demon.nl]
> Posted At: Thursday, December 05, 2002 4:07 PM
> Posted To: server
> Conversation: Oracle newbie
> Subject: Re: Oracle newbie
>
> On Thu, 5 Dec 2002 09:31:51 -0600, "Aaron M. Lowe"
> <sweetnlowe_at_telocity.com> wrote:
>
> >Hello,
> >
> >I'm a SQL DBA who has had experience with SQL Server 6.5, 7 and 2000.
> >However in addition to SQL, I just got added to my responsibilities to
> >manage an installation of Oracle 8.1.7 with at least two databases. I
> have
> >no experience doing anything with Oracle. Any suggestions on books,
> >courses, training material, etc that could help me?
> >
> >Thanks,
> >
> >Aaron Lowe
> >
>
> The Oracle Concepts Manual, online at http://tahiti.oracle.com as a
> first read, starting now.
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

Excellent advice from both Sybrand and Norman to which I will add the following:

Do not under any circumstances approach anything in Oracle assuming it works the same or is even remotely related to what that word or concept means in SQL Server. Even basic words such as DATABASE mean entirely different things. The architecture is completely different. In Oracle temp tables are almost never used and even less rarely required. We have something you've never heard of called multiversioning that is as basic as you can get to Oracle and yet has no equivalent in SQL Server. Also be sure you understand, completely, the implications of writes not blocking reads and reads not blocking writes.

Best of luck. And invest as much effort in unlearning as you do in learning.

Daniel Morgan Received on Thu Dec 05 2002 - 13:15:04 CST