Originally posted by slimdave
What a terrible way to design a database.
I agree with SlimDave on this. Have you thought about changing your schema to use just one set of tables, partition them based on company, and then use Oracle row level security to control who can see what company.

You might also look into SQL Loader for moving the data. You could transform the data as you take it out of the database, compress the file and then ftp it to your test system.