Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: create table initial max ?
>>
>> I agree with Howard, this is a crazy request, but slightly funny, so
>> here goes:
>>
>> 1) Make sure the autoextend is off for all the datafiles of the TBS in
>> question.
>>
>> 2) Run this :
>> create table foo(c1 number(10)) tablespace footbs;
>> begin
>> while true loop
>> execute immediate ('alter table foo allocate extent');
>> end loop;
>> end;
>> /
>>
>> and when it hits ORA-01653, you're done.
>>
>> - Kenneth Koenraadt
>
>Not what he asked for, Kenneth. He asked to fill a tablespace by
>specifying as big an initial extent size as possible, not for a table to
>merely fill up all the available space in a tablespace by extending as
>often as possible.
>
>Regards
>HJR
The result is the same.
And I think you interfer too much, Howard.
And I think you consider this newgroup your personal property.
And I think that no matter how much you know about Oracle it does not justify such appearance.
Why ? You could be a guru, well-known for your helpfull-ness and knowledge. Instead you become a social handgranate which no-one wants to deal with.
I know that kind of person from my career. They are excellent technicians, but noone wants to work with them and they are left in the corner and eventually fired. Don't become one of them.