Re: Oracle 8i (8.1.7.0.1) + Redhat Linux 7.2 = Cannot create tablespace file > 2 gb

"Joe Salmeri" <JoeSalmeri_at_comcast.net> wrote in message news:JPbT8.504153$Oa1.33629956_at_bin8.nnrp.aus1.giganews.com...
> "Howard J. Rogers" <dba_at_hjrdba.com> wrote in message
> news:afjdvd$kl0$1_at_lust.ihug.co.nz...
> > Mmmm. However, professionalism is in the eye of the beholder.
> >
> > Consider these choice quotes:
> >
> > "I don't just blindly post requests for help until I have exhausted all
> > other
> > possibilities." Swiftly followed by " I have pulled out the B&R guide
> > because you
> > are correct it has been quite a while."
>
> Totally out of context.

Uh huh. "I've exhausted all other possibilites". And "I haven't read that manual in quite a while". Yup, I see the context alright.

>There is no relationship between the two comments
> at all. The original comment was made because I had searched for several
> days for an answer to my original question (which has really never been
> answered BTW) and was basically told to do a Google search (my first step
in
> the research).

Another reason I'd sack you if you were my DBA. You go to Google *before* reading the manuals?

>
> The second was made regarding a topic that really has nothing to do with
the
> original question. Of the 3 available backup options, I don't use the one
> that you commonly use, I have always used the other two.
>
> > "The backup you suggest is worthless to me."
>
> I see nothing wrong with saying that I do not see the value in the
> suggestion made.

I see nothing wrong with someone saying "I don't do that sort of backup, but thanks for the tip". I see everything wrong with "your suggestion is worthless", which you came perilously close to saying.

>All that means is that I do not see or understand what
> value it provides.
>

Shame you couldn't say it that way, then.

> > "In your mind."
>
> I don't see anything wrong with having a different opinion than someone
> else.

Strangely enough, what Oracle does with extents, and how it reads them, isn't a matter of "opinion". It's measurable, testable, and demonstrable. So it wasn't "in my mind" (dismissive) but "not in my experience" (open to debate).

>It was even made in response to message that did not agree with my
> opinion.
>
> > I won't point out who made all these prime comments, nor what the
context
> of
> > each was. You know who you are, and can read a thread.
>
> Try as you may I will not stoop to your low level and quote all of the
> arrogant comments you have made. It's just not worth wasting my time.

I don't want you to quote "arrogant comments". I'd like you to actually *learn* something.

But feel free to go ahead and make my day.

All I have done in this entire thread is to make the following unarguable comments:

1. the number of extents is of no importance until you get into the thousands (several hundreds if dictionary managed)
2. therefore striving officously to make a segment fit in one extent is pointless
3. given a table doesn't need to fit in one extent, you have no need of enormous datafiles
4. enormous datafiles are not good for database management, flexibility or administrative options
5. you don't seem to know very much about Oracle internals, or backup and recovery principles, so I don't rate your ability to performance test reliably very highly.

Now.... which one of those would you like to take issue with?

HJR Received on Sat Jun 29 2002 - 01:07:18 CDT