Cursor without a where clause...

Hello:

    I am stuck up with a performance problem involving a cursor. I am moving data from a huge table ( rows > 300,000,000 ) with business validation done through a set of plsql procedures. Till date I am unable to complete the full move in one step. I am opening a cursor on the huge table without any WHERE clause, and because of which things are slowing down.

    I have tested with small chuck of data in steps and the completion time is rising exponentially. like 5 mins for the first 100000 recs, 15 mins for first 200000 recs and so on.

    Can someone suggest me any hints to speed up this blind cursor method ? Also I am thinking about partitioning the table but I am not sure whether this will be of any help.

Thanks in Advance.
justvrk

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Apr 19 2000 - 00:00:00 CDT