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
How big is your table? How many rows fit into a block? How many
freelists and freelist groups? Are you doing a lot of updates? What
are your storage parameters?
--
Ron Reidy
Oracle DBA
Received on Fri Jan 04 2002 - 05:54:23 CST
