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

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: 4 Jan 2002 04:19:58 -0800
Message-ID: <a8aed4.0201040415.336d9530@posting.google.com>

rastapoppolous_at_yahoo.com (humble_one) wrote in message news:<42bb2f93.0201032101.7d03c493_at_posting.google.com>...
> 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

May be u have reached Maxextents on u'r Table, tablespace or the Maxsize on u'r File.

So Check out all these ....

HTH Regards,
Ganesh R Received on Fri Jan 04 2002 - 06:19:58 CST