Re: EXTEND INDEX
Date: Fri, 03 Jul 2009 17:48:11 +0200
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
> 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?
-- remember.guy do |as, often| as.you_can - without end http://blog.rubybestpractices.com/Received on Fri Jul 03 2009 - 10:48:11 CDT