on 02-23-2015 12:30 PM
Hi All
SAP recommended that we backup and delete the entries in change tracker every 10 months. Is there a way to restore the backup in to change tracker without corrupting the production database.
Kind Regards,
Ajay
Hi Ajay,
MDM does not have tools for data archiving,as suggested above you can use DB tools to archive the history table.The below can shed some light,SAP recommends -
If your DBMS is Oracle, use a utility of your choice to archive your table (backup, dump) and afterwards clean the A2I_CM_HISTORY table using the the truncate command (with the reuse storage option). Remember that you must backup the table before issuing a truncate command since this command is not reversible (it does not generate role back logs!).
Thanks,
Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Use database tools to archive the A2i_cm_History table data, and restore it when necessary.
BR,
Carlos
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.