R: Table Definition - Space Problem

From: Riccardo Ferrari <riccardo.ferrari_at_informatica2.it>
Date: Tue, 9 Nov 1999 14:08:50 +0100
Message-ID: <8096f8$nlj$1@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 - 07:08:50 CST