Oracle Database Discussions

Here’s the scoop:

I have 1 system that I want to be able to load some tables from a different system over a database link. I can do something like CREATE TABLE XXX AS SELECT * FROM XXX@DBLINK. The problem I have is that I need to COMMIT after about 100 rows since some of the tables I am copying are huge. I am not using SQL*PLUS so autocommit is not an option. This is being implemented in a PRO*C program and I don’t necessarily know the tables to copy in the source code (I get the list from DBA_TABLES where OWNER = XXXX). I was thinking along the line of Dynamic SQL but have not implemented something that could select and insert without specifying the exact column names. Any ideas? I lost my PRO*C book (I think somebody took it!!!)