Table SWWCNTP0 size 14 Million records

[Sample, Rick]

See prgm RSWWWIDE_DEP
 
Rick Sample | Office (314) 573-5822 | Mobile (314) 952-2273 |
rick.sample at graybar.com 
www.graybar.com <http://www.graybar.com/>  - Graybar Works to Your
Advantage 
 

________________________________

From: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu] On Behalf
Of Scheinoha, John
Sent: Friday, August 28, 2009 11:24 AM
To: SAP Workflow Users' Group
Subject: RE: Table SWWCNTP0 size 14 Million records


Adam,
 
   We will be upgrading from ECC 5.0 to ECC 6.0 in the upcoming weeks.
Look at OSS Note 893602.  It references other SAP OSS Notes and Oracle
Notes for scheduling re-org jobs, reconstruction options and
re-organizing Oracle tables.  I have seen other SAP Workflow User Group
e-mails in this same topic.
 
 
I hope this Helps,
John Scheinoha
Briggs & Stratton
(414) 256 - 5136

 
________________________________

From: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu] On Behalf
Of Adam Kheil
Sent: Friday, August 28, 2009 10:19 AM
To: Workflow group
Subject: Table SWWCNTP0 size 14 Million records


Hi All,
We are having a growth in transactional data  issue and the sizes of
these tables are growing signaficantly. 
 
SWWCNTP0 
SWWLOGHIST
SWWWIHEAD
SWPSTEPLOG
SWPNODELOG
 
However, active number of work items are very minimal. What is a best
approach to reduce the size of these. archiving? Any ideas will be
highly appreciated. We are on ECC6.
 
Thanks
Adam
 


________________________________

Get back to school stuff for them and cashback for you. Try Bing now.
<http://www.bing.com/cashback?form=MSHYCB&publ=WLHMTAG&crea=TEXT_MSHYCB_
BackToSchool_Cashback_BTSCashback_1x1>  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.mit.edu/pipermail/sap-wug/attachments/20090828/f25643f4/attachment.htm