Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to delete contents

Former Member
0 Kudos
553

Dear Guru's,

Im having a problem where i cant delete the content of table TRBAT using SAP tcode se16n(tcode dont exist) and

also os level command (hangs for too long)-> delete from SAPD21.TRBAT;

Is there any other way we can perform this?

Thanks in Advance.

1 ACCEPTED SOLUTION

Former Member
0 Kudos
188

hi,

GO to transaction SM30 and there you can delete the entries.

Regards,

Himanshu

5 REPLIES 5

Former Member
0 Kudos
189

hi,

GO to transaction SM30 and there you can delete the entries.

Regards,

Himanshu

kesavadas_thekkillath
Active Contributor
0 Kudos
188

hi moderators ...

There are so many duplicate therads seen from yesterday..Is this a technical problem or ???

venkat_o
Active Contributor
0 Kudos
188

Hi, <li> Goto SE14->Give table name->Click on EDIT button. <li> Besides Activate and Adjust database table you will see Delete Data radio button. Select that one and click Activate and Adjust database button. It deletes data. Thanks Venkat.O

Former Member
0 Kudos
188

Hi,

I encountered this error when try to delete from tcode se14:

Request: Delete and recreate Table TRBAT (BASISADM1/27.08.09/14:43)

Process: kulnw01q_2

Enhancement category for table missing

Enhancement category for include or subtype missing

VARIANT already active and reserved (If possible, select another name)

If activation was successful, adjust C structures (where necessary)

Test activation of Table TRBAT successful

Activation and DDL statements for Table TRBAT required

Activate table TRBAT (BASISADM1/27.08.09/14:43)

Enhancement category for table missing

Enhancement category for include or subtype missing

VARIANT already active and reserved (If possible, select another name)

If activation was successful, adjust C structures (where necessary)

Table TRBAT was activated with warnings

sql:

DROP TABLE "TRBAT"

ORA-00054: resource busy and acquire with NOWAIT specified

DDL time(___1): ........40 milliseconds

TRBAT could not be removed

Statements for Table TRBAT could not be executed

Request for TRBAT could not be executed

Former Member
0 Kudos
188

Thanks Gurus for your kind advice, i managed to resolve this issue. Below are the steps on how i resolved it:

1. Stopsap

2. Login to SQL and start db.

3. Execute command --> delete from SAPD21.TRBAT;

4. Execute command --> commit;

5. Shutdown SQL

6. Login as sap admin and startsap

Then when i login to system and check on tc se16 table trbat. Entry was empty.

Thanks again guru's