Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help ora-01652
Your temp segment is not large enough to accomodate what you are trying to
do. Try adding a datafile to it. I think the syntax is:
ALTER TABLESPACE TABLESPACE_NAME ADD DATAFILE 'PATH\FILE_NAME' SIZE.
Andreas Rath wrote in message <6mtf4h$14t3_at_ppd00021.postag.de>...
>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 Sun Jun 28 1998 - 00:00:00 CDT