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