Hi,

You can load production data which are not found in your test table with following:

insert /*+ direct */ into test_table select * from prod_table minus select * from test_table;