topic Delete 100,000 Rows from Versioned Table? in Data Management Questions

Delete 100,000 Rows from Versioned Table?

Anonymous User — Thu, 15 Mar 2012 13:33:36 GMT

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

Re: Delete 100,000 Rows from Versioned Table?

JakeSkinner — Thu, 15 Mar 2012 15:58:58 GMT

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.

Re: Delete 100,000 Rows from Versioned Table?

Anonymous User — Thu, 15 Mar 2012 17:38:58 GMT

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.

Re: Delete 100,000 Rows from Versioned Table?

DeminHu — Mon, 19 Mar 2012 12:02:42 GMT

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 .

Re: Delete 100,000 Rows from Versioned Table?

ducksunlimited — Mon, 19 Mar 2012 19:55:02 GMT

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.