Hi experts,
I want to delete dat from DSO (more 10 Million records), I use DSO right clic ==> Manage ==> Delete Content,
The process take long time witout in error message
When I see the process in "SM50" or "SM66" I have this
============================================
** The last statement SQL
SELECT
/*+
FIRST_ROWS (1)
*/
COUNT(*)
FROM
"/BI0/ALIV_DS0100"
WHERE
ROWNUM <= :A0#
==========================================
In idea plz for deleting data from a miduim DSO (more 10 Million).
Thanks and best regards
Ilyaebi
Hi Ilyaebi,
If the records(more 10 Million) are loaded using multiple requests try to delete by selecting few requests and repeat the same with the leftover requests.
Call T-Code: RSA1 > DSO > Manage > Requests Tab > Select few requests(Approx 5-10) > Delete.
Note: You may monitor the delete job (BIDEL*) by clicking on 'Batch jobs'
Hope this helps.
Regards,
Sai
Hi ILYAE
try not to delete by requests, when you delete it will take long time as DSO has to find the relvent data from Change log table too
Right click > Delete Data
or if you know the active and change log table names
use SE14, much faster
thanks
Hi Sai and Vk A,
Thank you for your reply,
Sai,
The records (more 10 million) are loaded using one requests (with DS 0FI_AP_04).
VK A,
I know the active and change log table names, but how can I do that with SE14?
Best regards
ILYAE
HI
SE14
Table > press enter
select "delete data" radio button and Click "Activate and adjust database"
thanks
Message was edited by: Vk A
Hi VK A,
Thank you expert, issue resolved with you solution.
How can I attribute 10 point for you? I'm new with SCN i was familly with sdn .
Thanks and best regards
ILYAEBI
HI
You should have checked as question,
i believe you still can convert this discussion to Question
thansk
HI VK A
I don't see this option fo this discussion?
Thanks and best regards
Ilyaebi
Hi Ilyaebi,
You will find this option while creating a discussion. By default this option is checked. I guess you will not find this option once the question is posted.
In order to award points, check the below link
http://scn.sap.com/docs/DOC-18475
Regards
Sai