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

Hi Chris,
thanks for responding to my post.
I think the tablespace which i am working on is (permanent) Dictionary-Managed, beacuse when i query the user_tablespaces i get for my tablespace.
INITIAL_EXTENT NEXT_EXTENT MAX_EXTENTS PCT_INCREASE EXTENT_MAN -------------- ----------- ----------- ------------ ----------

        131072 131072 4096 1 DICTIONARY The oracle manual that i read
http://www.is.mcgill.ca/oracle.817/server.817/a76956/tspaces.htm#9994 states that to alter table space names a typical command would on the lines of
ALTER TABLESPACE users

    DEFAULT STORAGE (

       NEXT 100K
       MAXEXTENTS 20
       PCTINCREASE 0);

and whant chris specified
ALTER TABLESPACE <YOUR_TABLESPACE_NAME_HERE> ADD DATAFILE '<YOUR_NEW_DATAFILE_NAME_HERE>' SIZE <YYY> M

is listed under the section "Locally Managed Temporary Tablespace".

Which approach should i follow.
I have another question in this regard, if i were to increase the size of next and maxextents would oracle automatically take care of extensions when the data is updated in large chunks.

Kindly excuse my naivete, as i am very new to this. Thank you once again
Karthik

chris_vowlesREMOVE_at_REMOVEhotmail.REMOVEcom (Chris Vowles) wrote in message news:<3c357be8.4510405_at_news.claranews.com>...
> 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
>
> a) 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
>
> ----------------------------------------------------------
Received on Fri Jan 04 2002 - 12:59:23 CST