I just tried a cartesian product/sort and the TEMP tablespace, which is set
up as temporary and using a tempfile was able to autoextend. Of course, the
next step is to set up a TEMP tablespace as temporary using a datafile, then
permanent and see what happens...volunteers?
In regards to the issue of not autoextending in the event of a statement
failure. If this were the case, then almost no autoextension would occur. If
I insert 10 million rows into a table, causing the datafile to autoextend, I
could issue a rollback and not 'save' the rows. However, the table would
still have allocated the additional space (and the HWM would be WAY out
there...).
Dan Fink
-----Original Message-----
Sent: Thursday, November 07, 2002 2:44 PM
To: Multiple recipients of list ORACLE-L
maybe temp segments don't cause an autoextend?
at least it's consistent
- "Fink, Dan" <Dan.Fink_at_mdx.com> wrote:
> Update... I tried the same test with 8.1.7 on Solaris 8. Same
> result...
>
> -----Original Message-----
> Sent: Thursday, November 07, 2002 1:09 PM
> To: Multiple recipients of list ORACLE-L
>
>
> I just manually expanded the file and the index build finished with
> no
> problem. I also set the USER_DATA ts as autoextend and it extended
> several
> times without error. The only difference is in the fact that the
> INDEX
> segment is initially created as a TEMP segment. Interesting....
>
> -----Original Message-----
> Sent: Thursday, November 07, 2002 10:34 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Dan,
> That's exactly, what someone described yesterday, it was LMT with
> autoallocate, and they made sure, that there was plenty of space on
> the hard
> drive for TEMP file to grow.
> The only difference: it was not Solaris - it was AIX.
>
> Igor Neyman, OCP DBA
> ineyman_at_perceptron.com <mailto:ineyman_at_perceptron.com>
>
>
>
>
> ----- Original Message -----
> To: Multiple recipients of list <mailto:ORACLE-L_at_fatcity.com>
> ORACLE-L
> Sent: Thursday, November 07, 2002 12:15 PM
>
> Igor and Yechiel,
> Thanks for the responses. I'm glad to hear that I am not the only
> one
> experiencing the problem.
> I should have also mentioned that the tablespace is LMT with
> autoallocate and is nowhere near the max size.
>
> Dan Fink
>
> -----Original Message-----
> Sent: Thursday, November 07, 2002 9:35 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi Paulo
>
> When creating an index, or CTAS, oracle use temp segments while
> building and
> rename them after the build finish. So if you do not have enough
> space you
> will get: unable to allocate TEMP segment.
>
> Yechiel Adar
> Mehish
>
> ----- Original Message -----
> To: Multiple recipients of list <mailto:ORACLE-L_at_fatcity.com>
> ORACLE-L
> Sent: Thursday, November 07, 2002 6:04 PM
>
> never heard on this problem but are u sure table the temp tablespace
> of the
> user executing the commeand is temp and not user_indx???
> regards
> Paulo
>
> -----Original Message-----
> Sent: quinta-feira, 7 de Novembro de 2002 15:39
> To: Multiple recipients of list ORACLE-L
>
>
> I have a 9.2 database running on Solaris 8. I'm creating some test
> tables
> with indexes. The USER_INDX tablespace's datafile is set to
> autoextend (as
> are TEMP and USER_DATA). When the system attempts to create indexes,
> instead
> of auotextending the datafile (there is plenty of space on the
> device), it
> throws an ORA-01652: unable to extend temp segment by 128 in
> tablespace
> USER_INDX error. If I manually resize the datafile and rerun it, no
> problems.
>
> Anyone else heard of this behavior? I can't find anything on Metalink
> that
> fits the problem definition.
>
> Dan Fink
>
>
Do you Yahoo!?
U2 on LAUNCH - Exclusive greatest hits videos
http://launch.yahoo.com/u2
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Fink, Dan
INET: Dan.Fink_at_mdx.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Nov 08 2002 - 09:53:39 CST
