Home » RDBMS Server » Performance Tuning » Issue of Space as Data is growing Rapidly. (racle 9.2.0.4.0 Database)
Issue of Space as Data is growing Rapidly. [message #391366] Wed, 11 March 2009 23:45 Go to next message
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
Re: Issue of Space as Data is growing Rapidly. [message #391371 is a reply to message #391366] Thu, 12 March 2009 00:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Issue of Space as Data is growing Rapidly. [message #391429 is a reply to message #391366] Thu, 12 March 2009 04:30 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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
Re: Issue of Space as Data is growing Rapidly. [message #391435 is a reply to message #391429] Thu, 12 March 2009 04:41 Go to previous message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Gee! Didn't see it, I even thought the answer I gave here was in another forum. Laughing

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


Current Time: Wed Dec 07 14:27:05 CST 2016

Total time taken to generate the page: 0.17178 seconds