Delete 100,000 Rows from Versioned Table?

Question

Hello!  I need to delete 100K rows from a versioned table, but was unsuccessful using the typical ArcMap => Select => Delete.  I am tempted to delete the records directly in Oracle, but am not certain what impact bypassing the Deletes table will really have.  What is the best method for removing this many records?
Thank you!

ArcSDE 9.3

ducksunlimited · Answer

i guess the problem is that you are deleting large amount of records in a VERSIONED table. unregister it as version first then delete would work, but if it's replicated and couldn't be unregistered, really there is no easy way to achieve that including that in DBMS level. 
No error--the post took hours, and then appeared as though it had finished.  But no records were actually deleted, which we could see both in the map and in the deletes table.  I did see the "Delete Rows" tool, but wonder if I would get the same result as what I already tried.

DeminHu · Answer

I am no sure this will work for your case, but when I delete or load large amount records, I used to unregister as versioned, after the job done, then register as version .

Anonymous User · Answer

No error--the post took hours, and then appeared as though it had finished.  But no records were actually deleted, which we could see both in the map and in the deletes table.  I did see the "Delete Rows" tool, but wonder if I would get the same result as what I already tried.