Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Table Definition - Space Problem
You should query the largest free segment (from DBA_FREE_SPACE) in your
tablespace, if this will smaller then the table's initial value, that is a
problem.
>> Does Oracle try and grap 30 contiguous megs of space? --Yes
feherl
Riccardo Ferrari wrote in message <8096f8$nlj$1_at_nslave1.tin.it>...
>The error you get is:
>
>ORA-01653: unable to extend table name.name by num in tablespace name
>
>So the problem is not in table definition but in tablespace definition.
>You have to ask DBA to modify storage features of the involved tablespace
>(resizing datafile, adding datafile, enabling autoextend ...).
>
>Hope to be useful
>Riccardo
>
>
><NeedaHoliday> wrote in message 382819e2.19407488_at_news.pwgsc.gc.ca...
>> Can anyone tell me why I get and ORA-01653 error when I try to write
>> to a table. There is 300M available on the server and database. The
>> table size is approx 30M. The definition is 30m init 10m extents.
>> Does Oracle try and grap 30 contiguous megs of space? Is there a
>> definition value when defining the database? I asked the DBA and he
>> used the defaults when he defined the base.
>>
>> REMOVEjames.stewart_at_pwgsc.gc.ca
>>
>> Please omit REMOVE to email
>>
>> Thanks
>
>
Received on Tue Nov 09 1999 - 11:53:23 CST