REPOST: Re: Oracle 9i with 8i OCP track possible?

I wouldn't recommend it. But then I'm whistling in the wind here, because everyone else assures me that the differences between 8i and 9i are not that major. Personally, and speaking only for myself, I think that's wrong. The differences may not be enormous, but they arise in some of the really fundamental areas, like rollback segments, locally managed tablespace, freelists and so on. Sure, you can make 9i behave like 8i in most of these respects (you don't need to activate automatic undo, for example; and you can still use freelists if you choose). But a default installation and database implements many of these 9i-specific features, and you have to go to some effort to un-set them -and unsetting them really rather assumes that you know what they behaved like in 8i to start with!

Of course, someone is bound to ask why you don't simply study 9i and get the 9i OCP.

And I'm not saying that what you propose is simply not going to work. But I think it will be messy.

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"blurg" <blurg_at_gluipzak.nl> wrote in message
news:e3d01a7f.0112300419.4faaea6c_at_posting.google.com...


> Hello,

>

> I was busy today with Oracle 8i for Linux (Debian), and I think Oracle

> 8i for Linux really sucks! tried a lot of things and I've never seen

> so much errors in one day. On the Internet everyone is complaining

> about this Oracle 8i for Linux, loads of problems etc.

> I want to proceed with my OCP, and I would like to know if it is a big

> deal to install 9i and studying the 8i books with it.

> Will there be troubles for me in it because of important differences?

> Oracle 9i install was much more easier.

>

> Greetings Blurg.

>

> <footer>

> http://weirdscience.nl

> </footer>


========= WAS CANCELLED BY =======:
Path: news.sol.net!spool0-nwblwi.newsops.execpc.com!newsfeeds.sol.net!news-out.visi.com!hermes.visi.com!newsfeed1.earthlink.net!newsfeed.earthlink.net!uunet!lax.uu.net!news.navix.net!u-n-c-a-n-c-e-l-l-e-r
From: "Howard J. Rogers" <dba_at_hjrdba.com>
Newsgroups: alt.config,comp.lang.c,comp.databases.oracle.server
Subject: cmsg cancel <3c2f694d$0$2602$afc38c87_at_news.optusnet.com.au>
Control: cancel <3c2f694d$0$2602$afc38c87_at_news.optusnet.com.au>
Date: Mon, 31 Dec 2001 07:39:14 GMT
Organization: Navix Internet Subscribers
Lines: 2
Message-ID: <cancel.3c2f694d$0$2602$afc38c87_at_news.optusnet.com.au>
NNTP-Posting-Host: 166.102.15.34
X-Trace: iac5.navix.net 1009788716 26548 166.102.15.34 (31 Dec 2001 08:51:56 GMT)
X-Complaints-To: abuse_at_navix.net
NNTP-Posting-Date: 31 Dec 2001 08:51:56 GMT
X-No-Archive: yes
Comment: Anarchy! Fuck You!
X-Commentary: I love NewsAgent 1.10, Sandblaster Build 74 (19 March 1999) and the Polaris Cancel Engine V. 6.1
X-Unacanc3l: yes

This message was cancelled from within Mozilla...not