RE: Space management failures on autoextend datafiles

[Paulo Gomes]

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-----
From: Fink, Dan [mailto:[EMAIL PROTECTED]]
Sent: quinta-feira, 7 de Novembro de 2002 15:39
To: Multiple recipients of list ORACLE-L
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