>I know that, I can get same result by transfer the cursor record by record in scan loop.
>But in this tecnique at one time tranfer periyod is very long for 500.000 records. I hope to shorten execution time by transfering cursor.
You should consider using DTS.
--sb--