SQL Language (MOSC)

MOSC Banner

Mass/Bulk Delete assistance needed...

edited Feb 18, 2010 4:41AM in SQL Language (MOSC) 3 commentsAnswered
Hello, all.  I'm trying to do a mass delete in 10g on a table with 2M records.  I need to delete 530K records.  I wrote a simple "Delete from table where field=value to be deleted" query two days, and its still running.  When I do a Select count(*) for these records, they are still in the table.  They have not been deleted after 2 days.  Any pointers would be appreciated.  Can someone suggest a way of doing this in chunk, say a Commit after every 5K records, etc.

Thanks,

Roz

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center