cancel
Showing results for 
Search instead for 
Did you mean: 

sapsr3.crmcont delete older data

Former Member
0 Kudos

hello,

sapsr3.crmcont is getting bigger. actual size is about 350Gb,

is there any way to sort rows by time, because i want to delete older data.?


br Flamur

Accepted Solutions (0)

Answers (1)

Answers (1)

Webster_Cui
Advisor
Advisor
0 Kudos

Hello Flamur,

I suggest you archive transactions from application level rather than directly delete big files from DB/Server.

Please go to Archive online help documentation for more details.

http://help.sap.com/saphelp_crm70/helpdata/en/e6/c66f3b6c980c3be10000000a11402f/content.htm?frameset...

Regards,

Webster

Former Member
0 Kudos

hello Webster,

thanks for answer.

i`m new to sap, but i know well oracle that's why i`m trying from database.

pleas can you provide me some steps how to archive table sapsr3.crmcont

br Flamur

Webster_Cui
Advisor
Advisor
0 Kudos

Hello Flamur,

No you cannot directly archive table but can archive old and unused transactions from application level. Then you will see the size of the table has been decreased.

Regards,

Webster

Former Member
0 Kudos

hello Webster,

as you told me i deleted some old transactions from application level but still didn't change the size of table. table rows are deleted but lob segment is still the same size. i tried to shrink space with [oracle]$ALTER TABLE sapsr3.crmcont SHRINK SPACE CASCADE;

and

[oracle]$ALTER TABLE SAPSR3.CRMCONT MODIFY LOB (CLUSTD) (SHRINK SPACE);

but it doesn't work because CLUSTD is secureFile LOB.

any idea how to get the space back?

Former Member
0 Kudos

Hello,

I have the same problem in my sap crm system. But i don't know what transaction i need to manage to avoid the size increment of the crmcont table.

How can i find what transactions have an access to crmcont table?

Thanks in advance and regards

Eug