on 10-29-2009 10:16 PM
In the homogeneous/heterogeneous system copy guide, I'm told to delete all entries in the tables DBSTATHORA, DBSTAIHORA, DBSTAIORA and DBSTATTORA.
Why do I need to delete all the entries in these tables? What are the entries in these tables for? What happens if I don't delete the entries from these tables?
Hi Jamal,
I believe you are talking about the tables DBSTATHORA, DBSTAIHORA,
DBSTATIORA, DBSTATTORA. These tables contain statistical
data (like performance) from the source system. Since that is of no use
in your new system you can delete it with the following command in
SQL*Plus as user sapr3 (or sap<sid> when using Basis >=610)
delete from DBSTATHORA;
Repeat this command for the other tables
or execute being in SQL> prompt
truncate <Tablename>
Hope this helps you to understand the pupose and how to delete them.
Regards
Sekhar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jamal,
Check this [link|http://help.sap.com/saphelp_nw04/helpdata/en/cb/f1e33a5bd8e934e10000000a114084/frameset.htm] and search with table names.
Thanks
Sunny
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.