A follow up to this. Let's say I delete records from the database from table A Would that free space be used for other tables or just reserved for table A future records?
On Nov 22, 10:21 am, patrick zandi <remedy...@gmail.com> 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 <rajatcome...@gmail.com>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 WWRUG11www.wwrug.comARSlist: "Where the Answers Are"_ > > -- > Patrick Zandi > > ___________________________________________________________________________ > ____ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > attend wwrug11www.wwrug.comARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"