cancel
Showing results for 
Search instead for 
Did you mean: 

Homogeneous/heterogeneous system copy

jamal_asi
Participant
0 Kudos

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?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (1)

Answers (1)

sunny_pahuja2
Active Contributor
0 Kudos

Hi Jamal,

Check this [link|http://help.sap.com/saphelp_nw04/helpdata/en/cb/f1e33a5bd8e934e10000000a114084/frameset.htm] and search with table names.

Thanks

Sunny