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

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: 4 Jan 2002 04:24:39 -0800
Message-ID: <a8aed4.0201040424.23980ad7@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

You Have reaced Maxextents on u'r Table or Tablespace Or still u have would have reached the maxsize in The File... Check these out.

Increasing Next will Only Prevent this Problem in the future not Solve it now...

HTH Regards,
Ganesh R Received on Fri Jan 04 2002 - 06:24:39 CST