I have a database schema which has many redundant tables for the same data, with the same columns (fields) in each one.
Each table represents measurements for a particular location at one time, e.g. hourly. The columns (fields of measurement) are the same and most are just numbers.
Currently each "Site" (location) has own table, with the same columns as the other sites.
I would like these combined into one table with a 'site' column that is a foreign key to the list of (about 30) sites. The SITE table exists already.
It would be good if this is a script (bash, PL/SQL etc) that can be run at any time on a Linux box.
To bid on this, I would like to know roughly which technique you are thinking of using and which language. I will show you the schema. Please include the word 'schmozza' in your bid so I know you have read this. I can also send you a database dump (about 700mb) or a VMware image which contains Oracle (about 12GB). I would like you to understand how to transfer and sync large files using UNIX and SSH.