Table Deletion

[Former Member]

I have a 12GB table on my r/3 system i want to delete - what is the procedure for deleting a table from the system?

Regards,

Moshe

[Former Member]

Hi Moshe,

you can delete the table from SAP as well as Oracle. if you want to delete from SAP goto the transaction SE11 and enter the table name which you want to delete. else want to delete from Oracle level perform truncate <tablename>.

it will helpful to you.

Thanks,

Praveen.

[clas_hortien]

Hello,

if you want to get rid of the table you can drop it with

drop table TableNameHere

If you want to keep the definiton of the table and only drop the data from

the table you can truncate the table with

truncate table TableNameHere

If you have a newer R/3 release (620 or higher) you probably have to change

into the table schema first by running

setuser 'sid'

and then run one of the above statements. sid is the lowercase SID of your system.

Best regards

Clas