> what is the proper way for copy data from big table to another database
> if table is bigger then avaiable RAM and we need to do this in one
> transaction?
> You know if we do
> SELECT * FROM SOURCE_TABLE - and table have e.g. 400 000 000 records
> then retrive it is impossible because of RAM

Actually, a result set will "spill-over" to a temporary sort file, so the amount of memory in use should not be that bad.

Create an SP and declaring/using a Cursor, that should allow you to walk the result inserting the rows into the new table while minimizing memory consumption.


Sean