Re: About ORA-01658 unable to create INITIAL extent for segment in tablespace <ts>

Marck wrote:

> Hi Gurus,
>
> Thanks for the advice and discussion for the autoextent subject, but,
> muy question continue without answer.....
>
> The MaxExtent is because i have a limit. Sad but true =S, well.
>
> so
> Why a creation of a table and a index is taking too much space that
> the initial ?=...
>
> ahd really what is the operation for estimating that space ?
>
>

[...]

The advice to use locally managed tablespaces with appropriate options is still by far your best solution. But if you just want to resolve the error you're getting, go no further than the following documentation found at http://tahiti.oracle.com. Note the mention of contiguous (unfragmented) space.

"ORA-01658 unable to create INITIAL extent for segment in tablespace string

     "Cause: Failed to find sufficient contiguous space to allocate INITIAL extent for segment being created.

     "Action: Use ALTER TABLESPACE ADD DATAFILE to add additional space to the tablespace or retry with a smaller value for INITIAL."

--Mark Bole Received on Mon May 10 2004 - 11:24:03 CDT