Convert multiple Oracle tables (same structure) into one - repost 2
This project received 11 bids from talented freelancers with an average bid price of $238 USD.Get free quotes for a project like this
Project Budget$30 - $250 USD
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.
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online