Re: Space management failures on autoextend datafiles

Hi Igor,

Glad you enjoyed Jonathan's talks! Next time, you'll have to join us at his seminar which followed AAOUG and wrapped up yesterday! I'm actually heading over to the hotel to pick him up and take hime to the airport in a few minutes. It was a really great three days. I think all 24 people we had really enjoyed themselves!

-Mark

PS I should have introduced myself. I walked right by you at AAOUG, and I saw the name tag "Igor Neyman", and I couldn't think why I knew the name! Now I know....;-)

On Thu, 2002-11-07 at 11:14, Igor Neyman wrote:
> I've heard about the same problem yesterday (while attending Ann Arbor OUG conference), unfortunately - no solution, I think, they opened TAR.
>
> BTW, it was very good conference, great presentations by Jonathan Lewis.
>
> Igor Neyman, OCP DBA
> ineyman_at_perceptron.com
>
>
>
> ----- Original Message -----
> From: Fink, Dan
> To: Multiple recipients of list ORACLE-L
> Sent: Thursday, November 07, 2002 10:39 AM
> Subject: Space management failures on autoextend datafiles
>
>
> 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

-- 
--
Mark J. Bobak
Oracle DBA
mark_at_bobak.net
"It is not enough to have a good mind.  The main thing is to use it
well."
 						-- Rene Descartes
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark J. Bobak
  INET: mark_at_bobak.net

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).