Re: Temp tablespace

From: Daniel E. Dodge <ddodge_at_future.dreamscape.com>
Date: Tue, 08 Dec 1998 12:42:28 -0500
Message-ID: <366D6504.2210D288@future.dreamscape.com>

You most likely do not have a single extent in the tablespace large enough to create the table, or Oracle cannot allocate a next extent. Check dba_extents to see what the largest extent is left in the tablespace. You may have to back off on the size of the initial extent.

Dan

mgogala_at_rocketmail.com wrote:
>
> In article <74gtum$i9n$1_at_news.monmouth.com>,
> "Roman Gelfand" <rgelfand_at_masmid.com> 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
> >
> >
> You probably havent specified the storage clause.
>
> --
> Mladen Gogala
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Dec 08 1998 - 11:42:28 CST