Delete 100,000 Rows from Versioned Table?

[847396730]

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

[JakeSkinner]

Did you receive an error when you attempted to delete the 100,000 records? 

Have you tried using the 'Delete Rows' tool in ArcToolbox?  You can make a selection, open this tool and run it on the feature class.  It will delete only the selected records.

[847396730]

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]

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 .

[ducksunlimited]

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.