Re: ORA-1652: unable to extend temp segment by 512 in tablespace

On 8 Oct 2005 20:04:28 -0700, "suresh" <softgem_at_gmail.com> wrote:

>the size I gave is 100 M, isn't that sufficient, can somebody explain
>how does the segment, extent, block size are related.
>

segments are made up of 1 or more extents, extents are made up of one or more blocks.
Also each segment has a segment header consisting of one block, in the first extent.
With a block size of 8k this means the minimum extent size is 16k. 64k is more common, as by default, Oracle will read 8 blocks with one disk I/O (this is OS dependent and governed by db_file_multiblock_read_count)

>I was able to create tables by setting autoextend on and giving user
>grant access for unlimited tablespace
>
> GRANT CONNECT,RESOURCE,UNLIMITED TABLESPACE TO insite_adm identified
>by testing;
>
>
>Also I am trying to create just tables so does oracle allocates space
>upfront for that table?

It does. For every segment you create Oracle will allocate 1 extent. The size of the extent is determined by the INITIAL setting in the STORAGE clause, or by the DEFAULT STORAGE clause for the corresponding tablespace, when the STORAGE clause for the CREATE TABLE statement is absent.

--
Sybrand Bakker, Senior Oracle DBA