From: CenturionX <darwinbaldrich_at_gmail.com>
Date: Thu, 2 Jul 2009 16:43:27 -0700 (PDT)
Message-ID: <d3b4039c-eb9e-4f9f-a327-bd0d8973edb7_at_c36g2000yqn.googlegroups.com>

Hello everybody,

I'm working with Oracle 10g on Windows. I 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. Received on Thu Jul 02 2009 - 18:43:27 CDT

Original text of this message