Re: Segment management auto clause

I should, of course, also have said that I am delighted that you published your test method.

It gives us all the chance to go through the three useful possible responses:

1. My system is supposed to do that too, I wonder if that's why the results I see are the way they are
2. That test doesn't match what my setup looks like, but if I change it "like this", then I can see if it makes any difference
3. I think I see a hole in that test case that needs investigation.

Of course, there is the dodo response -

    d) Ooerr - that looks like hard work,

        I'm not going to read it.

I am, of course, intensely irritated by your posting, because I am currently sitting here with nothing to do whilst a 2GB tablespace is abuilding ;)

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html



____Denmark__May 21-23rd

____Sweden___June

____Finland__September

____Norway___September


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html


____UK_(Manchester)_May x 2

____Estonia___June 4th - 6th

____Australia_June 18th - 20th (Perth)

____Australia_June 23rd - 25th (t.b.a)

____USA_(CA, TX)_August


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


"Richard Foote" <richard.foote_at_bigpond.com> wrote in message
news:zJrwa.34254$1s1.498229_at_newsfeeds.bigpond.com...
> (WARNING: a touch on the long side !!)
>
> SQL> create tablespace assm
>   2  datafile 'c:\bowie\assm01.dbf' size 2000m
>   3  segment space management auto;
>