Home » RDBMS Server » Server Administration » Index file full
Index file full [message #54183] Fri, 01 November 2002 23:00 Go to next message
KSA
Messages: 1
Registered: November 2002
Junior Member
Hi,
One of our index file is reaching is allotted size of 500Mb, its grown to 97.23% of its allotted size. Can someone tell me how to reduce/trim/downsize the index file. Is there any way out. Iam a newbie to this area.
Pl help
Rgds

Report message to a moderator

Re: Index file full [message #54191 is a reply to message #54183] Mon, 04 November 2002 06:16 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
rebuild the indexes.
coalesce the tablespace.

Report message to a moderator

Re: Index file full [message #54196 is a reply to message #54183] Mon, 04 November 2002 10:28 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
No point of reducing the datafile size if it full with data, but to see what is the size to which you can reduce the size, use This Script

Your index tablespace might not have contiguous space to hold new extents, too. Check this with This Script

And finally, if you have to rebuild the indexes in this tablespace - refer to This Procedure

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: Data Archiving issue
Next Topic: Using links to fix a problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 19:00:12 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.