5000 radku zase neni tak moc.

-- tady si uprav datove typy
DECLARE @COL1 varchar(20), @Col2 varchar(20)  

DECLARE cursTabule CURSOR FOR      
SELECT COL1, COL2 FROM OPENQUERY
(SQL2, 'select COL1, COL2 from bflmpsvz')

OPEN cursTabule          
FETCH NEXT FROM cursTabule
	INTO @Col1, @Col2
WHILE @@FETCH_STATUS = 0
BEGIN
	-- vlastni inserty 
	insert into ORACLE..SCHEMA.TABULE(COL1,COL2)
		values (@Col1, @Col2)
	FETCH NEXT FROM cursTabule
	INTO @Col1, @Col2
END

CLOSE cursTabule
DEALLOCATE cursTabule