Delete all entries from the following tables - Follow-up Activities (oracle)

[Former Member]

Hello,

I performed a homogeneous system copy of our development BW system with the database (oracle 11.2.0.3) from the BW production system!

I already start the oracle database and the SAP system in the target system/server (development BW system) and I´m doing some follow-up activities. One of this activities is (at the system copy guide 6.2.3.2 Activities at Database Level) is to delete all entries from the following tables:

DBSTATHORA, DBSTAIHORA, DBSTATIORA, DBSTATTORA

I tried to delete them using SQL Plus:

sqlplus /nolog

SQL> connect /as sysdba

SQL> delete from DBSTATTORA;

delete from DBSTATTORA

            *

ERROR at line 1:

ORA-00942: table or view does not exist

... and it show me that error message.

This is strange because when I go to transaction SE14 and check the DBSTATTORA I see that table exist and contain a lot of entries!

Why this is happened in SQL Plus!? I´m running the correct SQL statement for doing this type of task or not?

How can I delete the entries of that tables? Can I do that using the transaction SE14?

Can you help me please?

Thank you,

samid raif

[Reagan · Accepted solution]

Hello

sqlplus /nolog
SQL> connect /as sysdba
SQL> delete from DBSTATTORA;
delete from DBSTATTORA
            *
ERROR at line 1:
ORA-00942: table or view does not exist

It doesn't surprise me as you are not mentioning the schema name here. Instead it should be

delete from SAPSR3.DBSTATTORA;

Assuming the schema owner is SAPSR3. if the owner is different then replace that with the correct one.

Regards

RB

[divyanshu_srivastava3]

Use truncate

[former_member182657]

HI,

In place of

SQL> delete from DBSTATTORA;

you need to use it SQL > truncate table SAPSR3.DBSTATHORA;

similarly for others.

Regards,

Gaurav

[former_member188883]

Hi Samid,

Please use command

SQL> truncate table <schema>.DBSTATTORA;

Regards,

Deepak Kori