Re: Help ora-01652

Peter Chang <p-chang_at_ti.com> schreibt: > Hi,
>
> I 'm new as DBA. When I try to create an table in sqlplus, I got
> ora-01652 unable to extend temp segment by 3569 in tablespace art.
> Can someone help me to resolve it problem.
>
> tablespace_name: art tablespace_name: art
> file_id: 6 file_id: 9
> count: 1 count: 20
> max(blocks): 810 max(blocks):4726
> min(blocks): 810 min(blocks): 2
> ave(blocks):810 ave(blocls):655.3
> sum(blocks):810 sum(blocks): 13106
>

I think your tablespace art is to small. Use the ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the specified tablespace or create the object in another tablespace. I hope this will work. Received on Thu Jun 25 1998 - 00:00:00 CDT