on 02-13-2013 7:32 AM
JCDS
TADIR
TRDIR
ADRC
DWTREE
DDNTF
DD02L
/BIC/AZNOREC0200
Hi Avadhesh,
Refer SAP Note
706478 | Preventing Basis tables from increasing considerably |
It has details on housekeeping for each of the basis tables.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Good Day
"increasing Significantly" means preventing them from growing further or controlling its growth.
Maybe you meant to reduce the present size of these tables which is attained through a table reorg
Tables like TADIR, TRDIR, DWTREE, DDNTF, DD02L are very important to the ABAP.
http://help.sap.com/saphelp_nw04/helpdata/en/c4/3a6def505211d189550000e829fbbd/content.htm
http://help.sap.com/saphelp_40b/helpdata/en/57/38e06c4eb711d182bf0000e829fbfe/content.htm
Unfortunately there is no best practice for archiving / deleting the data from these tables and there are no housekeeping jobs to take care of this.
If your need is to reduce the size of the database especially these tables then you might consider doing a reorg of the database.
Cheers
RB
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.