Re: Temp tablespace

From: David Lane <dlane_at_cix.compulink.co.uk>
Date: Tue, 8 Dec 1998 21:51:57 GMT
Message-ID: <F3o22L.4Dn@cix.compulink.co.uk>

In article <74gtum$i9n$1_at_news.monmouth.com>, rgelfand_at_masmid.com (Roman Gelfand) wrote:

> I have a table which is 650 mb. When I do create table as, I am getting
> failed to extend temp by a number. Also, I have allocation 800 mb for
> temp
> tablespace.
>
> Can anyone tell me what is the problem?
>
> Thanks,
>
> Roman
>
>
>

Usually, this comes from not being able to find enough contiguous space for a single extent of 'initial' in the tablespace where you're trying to put the table . You can try giving a smaller initial size and then 'alter table allocate extent ...' to create extra extents (tring to keep the number of extents to a minimum!)

Dave Lane (dlane_at_pt.lu) Received on Tue Dec 08 1998 - 15:51:57 CST