Convert multiple Oracle tables (same structure) into one - repost 3

  • Status Closed
  • Budget $30 - $250 USD
  • Total Bids 13

Project Description

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.

Get free quotes for a project like this

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online