Personally I never use DBCA. The manual installation scripts that I've carried over
from my 8.0 days for Windows and HP-UX still work (with minor modifications) for 9.2.
Well, I lie. When I first install a new Oracle version I use DBCA to create a database
just to see what some of the new options
and the first thing that I do is to delete the INDX tablespace!!! As well
as dropping the ORD* users, SCOTT, Tim, Tammy-Fae, Jim Bob and all the other
crappy stuff that auytomatically gets installed.
I try and get it back to the original 8.0 install!!!
Tom Mercadante
Oracle Certified Professiona
> -Original Message-
> Paul Baumgartel
>
> Loney didn't write OFA, and methinks he was taking liberties with it.
Perhaps. However I notice that DBCA in Oracle 9.2 creates a tablespace called INDX.
http://download-west.oracle.com/docs/html/A97297_01/appg_ofa.htm#sthref807
Oracle9i Adminis
Loney didn't write OFA, and methinks he was taking liberties with it.
--- Jacques Kilchoer <[EMAIL PROTECTED]> wrote:
> Not commenting on the accuracy of the information, but Kevin Loney,
> in the Oracle8 DBA Handbook (1998), says the following (Chapter 3
> Logical Database Layouts), in a section
Oh man... now I see the problem.
Well, IMHO, Kevin's advice is the right advice for the wrong reasons.
It's not the OFA.
Thanks, Jacques, for pointing that out.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
Not commenting on the accuracy of the information, but Kevin Loney, in the Oracle8 DBA
Handbook (1998), says the following (Chapter 3 Logical Database Layouts), in a section
entitled "The Optimal Flexible Architecture (OFA)"
"Index segments should not be stored in the same tablespace as their ass
Steve,
Thank you. I am grateful that someone else shrugs too.
I still get a lot of feedback about the OFA. Almost every conference I
go to, someone forgives me for writing the OFA Standard. And I leave not
knowing for sure where things went wrong.
A few weeks ago, one of the Oracle-L threads wen