 Reclaiming free space questions [message #303890] |
Mon, 03 March 2008 02:43  |
kian.tern
Messages: 3
Registered: March 2008
|
Junior Member |
|
|
Hi all.
I'm fairly new to oracle and database administration.
Currently I have a huge database (1TB+).
There is a weekly cleanup running. But the space is not reclaimed.
I found this article
http://www.oracle.com/technology/pub/articles/10gdba/week15_10gdba.html
It seems that the space reclaim should not a problem.
But still I have some questions.
1. The database has a bad design and most of the data is located in 2-3 tables. Can this cause in a failure to reclaim free space?
2. Can this process "kill" the database if failed?
3. Can I run this on entire tablespace or do I have to run it on each table separately?
Thanks in advance.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Reclaiming free space questions [message #304733 is a reply to message #303903] |
Thu, 06 March 2008 07:22  |
hd999
Messages: 2
Registered: March 2008
Location: Austria
|
Junior Member |
|
|
Hi,
if you use the "shrink space": don't do it on tables/partitions with LOBs. If there is some action concerning lobs while you do the shrink, it might corrupt your LOB-data. At least, in 10.2.0.3 we saw that happening.
Also, if about all of the data is in a view tables, you will face problems with UNDO (very likely. which, after all, is no corruption).
regards,
Heimo
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
