Re: OCP Oracle 8i or 9i

From: Howard J. Rogers <howardjr_at_www.com>
Date: Wed, 31 Oct 2001 05:56:27 +1100
Message-ID: <3bdef7ab$0$23880$afc38c87@news.optusnet.com.au>

I won't disagree, but I can't wholeheartedly agree, either. Rollback segments are pretty fundamental to the database, and they've changed completely between 8i and 9i. RMAN was a swine in 8i, works like a charm in 9i. Auto-management of files means every 'create tablespace' statement is likely to look completely different. Even the 'create database' statement has got two new entries in it (auto undo and default temp). The pfile has turned into an spfile, server manager has gone, export now does genuine tablespace-level exports, and flashback makes an appearance.

There are a *lot* of fairly fundamental changes, and I'm not salivating at the prospect of having to teach it to people who actually use 8i.

Of course, at the end of the day, it's still Oracle, and yes, a good grounding in 8i wouldn't send you wildly astray in 9i. But I wouldn't recommending mixing versions when it comes to OCP, nor if you are just starting out.

Regards
HJR

--

Oracle Resources : http://www.geocities.com/howardjr2000
========================================


"Marc Blum" <marc_at_marcblum.de> wrote in message
news:3bdedc81.3895821_at_news.online.de...


> Studying 8i won't lead you in the wrong direction! Oracle 9 isn't a

> completely different animal than Oracle 8. What you knew about Oracle

> 7 didn't became worse with Oracle 8. What you know about Oracle 8

> doesn't become worse with Oracle 9. Sure some features become obsolete

> and there's a whole bunch of new stuff, but the main part of your

> knowledge remains valid.

>

> On 28 Oct 2001 20:04:19 -0800, antonio_homepage_at_yahoo.com (MaG) wrote:

>

> >Hello,

> >

> >I'd like to start studying for the Oracle DBA certification, but I'm

> >not sure which version of Oracle I should study for. 9i is the latest

> >version, but its OCP track from Oracle University still offers beta

> >exams. The Oracle 8i track, on the other hand, is the best organized,

> >but I'm afraid this track may become obsolete by the time I get to the

> >last exams.

> >

> >Do you know which track I should choose?

> >

> >Thanks.

>

> regards

> Marc Blum

> mailto:marc_at_marcblum.de

> http://www.marcblum.de

Received on Tue Oct 30 2001 - 12:56:27 CST