Axton: I saw your example in this posting. This example has for a H
table. Is the following correct for T and B tables? I am using Oracle.
create table H75_tmp as select * from H75 where entryid in (select c1
from T75);
truncate table H75;
insert into H75 select * from H75_tmp;
drop table H75_tmp;
create table T75_tmp as select * from T75;
truncate table T75;
insert into T75 select * from T75_tmp;
drop table T75_tmp;
create table B75_tmp as select * from B75;
truncate table B75;
insert into B75 select * from B75_tmp;
drop table B75_tmp;
Thanks
Ravi
Axton wrote:
** You have to run a truncate if you want to reset the high water
marks and release the storage. It's ok to do things in sql against
the db, you just need to have an understanding of what you are doing
and how it impacts the db, and in turn the applications. Ignorance is
bliss, unfortunately it doesn't get you far.
A truncate is like 'delete all', plus some other operations. So long
as you clear the T, H, B, B#C tables when truncating one, you will not
have a problem.
Axton Grams
On Nov 26, 2007 11:41 AM, Ravi <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> wrote:
Hi: The diskspace keeps showing high usage even after I have
deleted all
records from all of the forms in my remedy instance. DBA is asking
me to
run a truncate. But I remember being told in remedy training not
do do
anything from sql prompt. I saw one email
(http://listserv.rbugs.com/cgi-bin/wa.exe?A2=ind0709&L=arslist&P=R220861&I=-3&X=23F4FB0752F26A51E6&Y=ravinm%40cox.net
<http://listserv.rbugs.com/cgi-bin/wa.exe?A2=ind0709&L=arslist&P=R220861&I=-3&X=23F4FB0752F26A51E6&Y=ravinm%40cox.net>)
which does run steps from the sql prompt. Can someone confirm if i can
actually run these (copy to a temp table, truncate the original table
and copy the stuff back to the orginal table) from sql prompt without
impacting Remedy operations?
TIA
Ravi
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
<http://www.arslist.org>
Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com>
ARSlist: "Where the Answers Are"
__20060125_______________________This posting was submitted with HTML
in it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
