8 Replies Latest reply: Apr 17, 2012 7:09 PM by Sai Prasad RSS

Delete data (more 10 Million) DSO from

ELYAE BI
Currently Being Moderated

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