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"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
