EXTEND INDEX
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,
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