Home » RDBMS Server » Server Administration » Reclaim Free Datafile Size (ERP, 11.5.10.2, Sun Solaris)
Reclaim Free Datafile Size [message #305644] Tue, 11 March 2008 08:04 Go to next message
suiren97
Messages: 48
Registered: May 2007
Location: Malaysia
Member
DB: 10.1.0.4.0 - previously upgrade from 8i.
1)
Due to space constraint, we are still not in OATM, so can't use SHRINK in 10g.
We are performing ALTER TABLE MOVE, REBUILD INDEX on few objects from BOM, GL, WIP, WSM every month with the purpose of improving performance by resetting the HWM.
However, understand from some forum that if the table need to be reused, there is meaningless to do the above operation - can someone pls advise on this?
2)
As budget constraint, we are not able to get 3rd party solution for the archive & purge for the time being.. but we need to perform this operation urgently due to data growth. Eventhough with the solution, after the archive & purge, we still need to reclaim the size if I'm not wrong.
Question:
Is it possible to perform the archive & purge without 3rd party solution?

How should I start with?



Re: Reclaim Free Datafile Size [message #305647 is a reply to message #305644] Tue, 11 March 2008 08:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
we are still not in OATM

What is that?

Quote:
How should I start with?

What did you search and find on this site or AskTom or...?

Regards
Michel



Re: Reclaim Free Datafile Size [message #305651 is a reply to message #305647] Tue, 11 March 2008 08:15 Go to previous messageGo to next message
suiren97
Messages: 48
Registered: May 2007
Location: Malaysia
Member
OATM - Oracle Applications Tablespace Model

Re: Reclaim Free Datafile Size [message #305655 is a reply to message #305651] Tue, 11 March 2008 08:21 Go to previous messageGo to next message
suiren97
Messages: 48
Registered: May 2007
Location: Malaysia
Member
Quote:
What did you search and find on this site or AskTom or...?



Can I know what do u mean here?
sorry if i'm not suppose to ask question like how should i start with in this forum..
Re: Reclaim Free Datafile Size [message #305660 is a reply to message #305655] Tue, 11 March 2008 08:35 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Searching for "reclaim space" for instance.

Regards
Michel
Previous Topic: Which session generate archive redo log
Next Topic: character set conversion problem
Goto Forum:
  


Current Time: Sun Dec 04 18:51:36 CST 2016

Total time taken to generate the page: 0.15608 seconds