Unable to delete contents

[Former Member]

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.

[Former Member]

hi,

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

Regards,

Himanshu

[kesavadas_thekkillath]

hi moderators ...

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

[venkat_o]

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]

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]

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