on 08-28-2010 2:24 AM
I have a 4 TB DB and I have archived or deleted about 1.5TB of data. I would like to shrink my overall size of DB from 4 to 2.5TB. I need to reclaim the OS space back as well. What is the best way to achieve this in Oracle 10g
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Chris
I would go for Reorganization followed by Shrink data files.
You can check the link below http://www.dbapool.com/articles/0805200802.html
Regards
Anindya
Edited by: Anindya Bose on Aug 28, 2010 11:12 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.