This should be a rare occurrence and you should have enough space on your boxes to grow and allow the DB tables to grow dynamically. I think of no real reason not to have the space. If you (for example) start using the attachments alot space is going to grow and you are going to be in the same boat, just sooner. If you are bumping against Physical limits.. Just get more disk, or more drives. Remember to divide if you are using physical drives, /u01 ~ /u08 for example placing different pieces in different disks. Otherwise if you are connected SAN wise, just add more disk..
Don't play games with that.. if for some reason you miss it, vacation.. and run out of disk.. You are not going to like the clean up to get yourself back to where you were! On Tue, Nov 23, 2010 at 5:10 AM, rajat sharma <[email protected]>wrote: > ** > Thanks...Patrick for the info... > Actually we are setting up a purging policy in our environmnet. If you or > anybody in this list can help us in finding which tables should > be purged and their frequency that would be of great help. > > Thanks, > Rajat > > On Mon, Nov 22, 2010 at 8:51 PM, patrick zandi <[email protected]>wrote: > >> ** you cannot reduce the size of the database (after creation) from the >> remedy side, >> >> you need an oracle DBA to assist you to reduce the DBF's >> >> http://www.orafaq.com/wiki/Oracle_database_FAQ -- This might help some >> ... >> >> The DBF's are like a jar and your data is the marbles in it.. you can pull >> 100 marbles from the jar, but the jar is still the same size. >> >> >> >> On Mon, Nov 22, 2010 at 9:20 AM, rajat sharma <[email protected]>wrote: >> >>> ** >>> Hi List, >>> >>> We are deleting recoreds from Remedy but it is not releasing space from >>> Database. >>> Please let me know if i need to check some settings. >>> Also let me know if i need to take help from DBA. >>> >>> Environment: >>> ARSystem: 7.5 patch002 >>> Platform: AIX >>> Database: Oracle 10g >>> BMC Atrium CMDB: 7.5 patch004 >>> BMC Drift: 7.5 >>> SRM: 2.2 patch003 >>> >>> Thanks, >>> Rajat >>> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ >> >> >> >> >> -- >> Patrick Zandi >> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ >> > > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ > -- Patrick Zandi _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
