Oracle-L: RE: Space management failures on autoextend datafiles

From: Fink, Dan <Dan.Fink_at_mdx.com>
Date: Thu, 07 Nov 2002 09:15:46 -0800
Message-ID: <F001.004FDF6A.20021107091546@fatcity.com>

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 ORACLE-L <mailto:ORACLE-L_at_fatcity.com> 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

--

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 Thu Nov 07 2002 - 11:15:46 CST