OraFAQ Forum: Performance Tuning » Issue of Space as Data is growing Rapidly.

Home » RDBMS Server » Performance Tuning » Issue of Space as Data is growing Rapidly. (racle 9.2.0.4.0 Database)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Issue of Space as Data is growing Rapidly. [message #391366]

Wed, 11 March 2009 23:45

tapaskmanna
Messages: 98
Registered: January 2007
Location: Cyprus,Nicosia

Member

Hi,

Due to numourous DML operation by DELETE there is increase in unused INDEX tablespace,
which were not removed, As Those can be removed by REBUILD INDEX.

If there is no downtime on Production, then how to proceed ?
Is there any option for ONLINE REBUILD INDEX in Oracle 9.2.0.4.0 Database?
What will be the Issue can arise as the tables contains Millions of records?

With Warm Regards
Sona

Report message to a moderator

Re: Issue of Space as Data is growing Rapidly. [message #391371 is a reply to message #391366]

Thu, 12 March 2009 00:09

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Is there any option for ONLINE REBUILD INDEX in Oracle 9.2.0.4.0 Database?

I think you'll find the answer in the documentation.

Quote:

What will be the Issue can arise as the tables contains Millions of records?

ORA-01555 and ORA-01410 in concurrent sessions.

Regards
Michel

Report message to a moderator

Re: Issue of Space as Data is growing Rapidly. [message #391429 is a reply to message #391366]

Thu, 12 March 2009 04:30

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Are you expecting a particular answer/response?
Why are you opening a new thread with the same topic again while not bothering to respond the previous one?
http://www.orafaq.com/forum/m/391237/42800/#msg_391237

Report message to a moderator

Re: Issue of Space as Data is growing Rapidly. [message #391435 is a reply to message #391429]

Thu, 12 March 2009 04:41

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Gee! Didn't see it, I even thought the answer I gave here was in another forum. Laughing

Regards
Michel

Report message to a moderator

Previous Topic:	BITMAP CONVERSION FROM/TO ROWIDS
Next Topic:	TNS-12518: TNS:listener could not hand off client connection

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 25 05:15:39 CST 2025