Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Create table statement, weird behavior...

Re: Create table statement, weird behavior...

From: Frank <fbortel_at_home.nl>
Date: Fri, 10 May 2002 18:56:58 +0200
Message-ID: <3CDBFBDA.9050009@home.nl>


Jim wrote:

> Frank,
>
> The reason why 81 extents is because it is a "Locally Managed". "Dictionary
> Managed" would create 1 extents.
>
> It took me a while to get it... But I've got it now.
>
>
> "Frank" <fbortel_at_home.nl> wrote in message news:3CDA6B91.90502_at_home.nl...
>

>>Tom, Jonathan,
>>
>>This is not the point here. The question is:
>>why would a mere create table statement allocate 81 extents
>>in a dictionary managed TS?
>>I wouldn't know the answer, but I think you guys do.
>>
>>Respectfully yours, etc,
>>Frank
>>
>>

>
>

My fault - rereading the thread there was a mention of "perhaps make it dictionary managed" - I wrongfully read it as this is dictionary managed.

Makes sense now.
Frank Received on Fri May 10 2002 - 11:56:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US