Re: Should I study Oracle 8i/9i or 9i directly/

Hi Howard,

I meant learning 9i, not just the 9i only features. I don't think Terry was suggesting just learning new features introduced in 9i but whether he should be 8i "literate" before becoming 9i literate.

If I was to put it into Oracle University/Education terms (which I wasn't, I took the training to be a generic term) this would mean doing the 9i DBA course, the 9i Backup Recovery/Networking course, the 9i Performance Tuning Course then perhaps to fill in the gaps, the 9i NF course. It's somewhat redundant to start learning 8i at this stage if you have a choice. Once you learn 9i, you implicitly learn 8i or the bits in 8i worth learning. Learning 9i means knowing LMT, knowing MVs, etc.

I believe if you are 9i "literate" and you have an 8i database put in front of you, you'll get by (just as someone who knows 8i would survive looking after an Oracle7 database). I don't believe the same would necessarily be the case the other way around and so my suggestion to 'read' the 9i Concepts manual in preference to the 8i and then read through the 9i one as well.

Then again, I could be wrong. Either way, it's get boring agreeing with you all the time, this is more like it ;)

Cheers

Richard

"Howard J. Rogers" wrote:
>
> Personally, I would recommend the 8i->9i route.
>
> There's a hell of a lot of new features in 9i, and many of them develop, or
> expand on, stuff that was introduced in 8i. Cut out 8i, and a lot of 9i is
> going to seem a bit mysterious. (For example: "Locally Managed Tablespaces
> are now the default". Great... but what's a locally managed tablespace??!
> "Materialized Views now Fast Refresh more readily than in 8i". Lovely... but
> what's a Materialised View, and what's Fast Refresh when it's at home?
>
> I can't speak for what other training organisations do (and I don't speak
> for Oracle, either), but the official Oracle 9i New Features course
> *assumes* familiarity with 8i new features.
>
> As was discussed here some weeks ago, too: going from 8i to 9i means that
> you are required to know about things like Advanced Replication and
> Workspace Management. Doing 9i direct would not require that level of
> knowledge. If you want an easy time of it, therefore, direct 9i is the way
> to go. But if you actually want to know, understand and use the product
> competently, the 8i -> 9i upgrade route is more thorough, and ultimately
> more productive.
>
> Regards
> HJR
>
> "Terry H" <LYYLAM_at_hotmail.com> wrote in message
> news:196e2f63.0208112207.70bccfbf_at_posting.google.com...
> > Hi,
> >
> > Please give me some advice.
> >
> > Should I study 8i -> 9i or study 9i directly?
> > Do you know any good Oracle training school in South bay of California
> > (alameda county or Santa Clare county)?
> >
> > Thanks.
> >
> > Terry H.