Re: help needed on ORA-01653: unable to extend table

On 3 Jan 2002 21:01:52 -0800, rastapoppolous_at_yahoo.com (humble_one) wrote:

>hi everyone,
> I get the error ORA-01653: unable to extend table KARTHIK.CLONE by
>165 in tablespace.
>
>i extended the tablespace by giving the command
> alter table clone storage (next 10k)
>
>I have lots of space to support the data that i want to load,
>my question is by how much should i alter the storage so that this
>problem doesn't occur again.
>I am loading a huge amount of data and this error causes a real pain
>as the loading process is interrupted.
>
>TIA,
>KArthik

The command you mention is not extending the tablespace

You need to either

1. increase the size of the datafile associated with your tablespace

ALTER DATABASE '<YOUR_DATAFILE_NAME_HERE>' RESIZE YYY M

b) add another datafile to your tablespace

ALTER TABLESPACE <YOUR_TABLESPACE_NAME_HERE> ADD DATAFILE '<YOUR_NEW_DATAFILE_NAME_HERE>' SIZE <YYY> M

Chris

Regards,

Chris