Home » RDBMS Server » Server Administration » Reorganizing Index-TBLSP
Reorganizing Index-TBLSP [message #56740] Tue, 22 April 2003 03:40 Go to next message
Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland
Senior Member
Hi All,

we've a huge problem with one of our 8.1.7 DB's. One of our index-Tablespaces is running out of space many times. We added datafiles, but we've lost space in any file. Now I suggest to reorganize this Tablespace, but it's our ODS-Database on which we're not able to design a downtime.
Is there any way to reorganize Tablespaces without generating a downtime in 8.1.7 ?

regards
Uwe

Report message to a moderator

Re: Reorganizing Index-TBLSP [message #56748 is a reply to message #56740] Tue, 22 April 2003 07:02 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
 
what kind of reorg u are looking into?
becuase rebuilding the indexes can be done online.
and wats the exact scenario?
is the space completely utilized 
or 
max extents reached?

Report message to a moderator

Re: Reorganizing Index-TBLSP [message #56753 is a reply to message #56748] Tue, 22 April 2003 08:23 Go to previous message
Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland
Senior Member
Hi Mahesh,

our problem is that we've to add nearly one datafile each week to this index. It's not that the max extents reached, but we've many free parts in all files. These free spaces wern't big enough for the next extent, so that the next insert will ask for more space.
The Index is that big by now (12 * 1,5 GB) so rebuilding will takes a long time. And this ODS is 24/7 so we will not found a suitable time.
Hope we can work without generating a time out, but I guess that's what we need.
regards
Uwe

Report message to a moderator

Previous Topic: Deinstallation of oracle server s/w
Next Topic: 100% CPU Utilization
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 09:30:02 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.