Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambriumusenet.nl!193.201.147.79.MISMATCH!transit4.hitnews.eu!feeder1.cambriumusenet.nl!feed.tweaknews.nl!209.197.12.246.MISMATCH!nx02.iad01.newshosting.com!newshosting.com!69.16.185.21.MISMATCH!npeer03.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!postnews.google.com!y10g2000prf.googlegroups.com!not-for-mail
From: CenturionX <darwinbaldrich@gmail.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: EXTEND INDEX
Date: Tue, 7 Jul 2009 08:02:12 -0700 (PDT)
Organization: http://groups.google.com
Lines: 40
Message-ID: <ada362af-5e1a-43da-8c25-02814ea1cc01@y10g2000prf.googlegroups.com>
References: <d3b4039c-eb9e-4f9f-a327-bd0d8973edb7@c36g2000yqn.googlegroups.com> 
 <bf8582de-b15d-4dc2-bec9-e171cdc6f68d@h18g2000yqj.googlegroups.com>
NNTP-Posting-Host: 205.151.83.2
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1246978932 1194 127.0.0.1 (7 Jul 2009 15:02:12 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 7 Jul 2009 15:02:12 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: y10g2000prf.googlegroups.com; posting-host=205.151.83.2; 
 posting-account=CR-wsQoAAADdIISljEiEL4sHO53YFCUC
User-Agent: G2/1.0
X-HTTP-Via: 1.1 SRV-MTL-ISA
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 
 1.1.4322; .NET CLR 2.0.50727; InfoPath.1; .NET CLR 3.0.04506.30; .NET CLR 
 3.0.04506.648; MS-RTC LM 8; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET 
 CLR 3.5.30729),gzip(gfe),gzip(gfe)
Xref:  news.cambrium.nl

On Jul 3, 3:03=A0pm, Mark D Powell <Mark.Pow...@eds.com> wrote:
> On Jul 2, 7:43=A0pm, CenturionX <darwinbaldr...@gmail.com> wrote:
>
>
>
>
>
> > Hello everybody,
>
> > I'm working with Oracle 10g on Windows. =A0I got this message:
> > 01654: unable to extend index MASTER.XPK_BR by 256 in tablespace DATA1
> > The tablespace where this index is located had 2.1 MB and it was at
> > %99.6 of use.
>
> > I searched in the web for a solution and i found this:
> > ALTER DATABASE DATAFILE DATAFILE1.DBF' AUTOEXTEND ON NEXT 20M MAXSIZE
> > 3000G;
>
> > The problem is that the tablespace continues at %99.6 even if the MAX
> > MB is increased.
>
> > How can i solve it?
>
> > Thanks.
>
> Until you actually perform an insert that cause an object to attempt
> to allocate another extent which in turn requires the data file to
> extend the percentage used for the tablespace is not going to change
> unless you issue a command to manually cause the file to extend first.
>
> See the DBA Administration manual which has information on managing
> tablespaces, data files, and objects.
>
> HTH -- Mark D Powell --- Hide quoted text -
>
> - Show quoted text -

Now it is working.

Thanks.