on 09-03-2015 12:18 PM
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
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.
Regards,
Webster
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
User | Count |
---|---|
8 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.