Deleting records *does not* release the space or what is called the 'high
watermark'.
You would need to truncate the records to lower the high watermark.
Beware though that a delete operation can be rolled back by a rollback
transaction before a commit, but truncate does not support a rollback. You
need to be absolutely sure before you truncate as data once truncated cannot
be rolled back without a database restore. It would be advisable you take a
database backup before you perform truncate operations..
Cheers
Joe
-----Original Message-----
From: remedy lee
Sent: Monday, November 22, 2010 11:21 AM Newsgroups:
public.remedy.arsystem.general
To: [email protected]
Subject: Re: Purging not releasing space
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 <[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 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"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
