Re: EXTEND INDEX

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Fri, 03 Jul 2009 17:48:11 +0200
Message-ID: <7b6nhuF21kbitU1_at_mid.individual.net>

On 03.07.2009 01:43, CenturionX wrote:

> 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?

Did ORA-01654 persist? Did you read documentation about how to interpret the reported figures about % usage? What did it tell you?

Kind regards

        robert

-- 
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/

Received on Fri Jul 03 2009 - 10:48:11 CDT