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

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.

Skills: Database Administration, Oracle

See more: tables in data structure, table data structure, sql oracle pl sql, sql in pl sql, pl sql in oracle, pl sql files, pl sql and oracle, oracle sql pl, list of data structure, list in data structure, list data structure, key data structure, if oracle pl sql, for in pl sql, for i in oracle pl sql, data structure list, about data structure, pl sql oracle, oracle sql with, is into one word, in pl sql, same, oracle:pl, oracle pl/sql, oracle pl

About the Employer:
( 0 reviews ) India

Project ID: #5551583

13 freelancers are bidding on average $147 for this job


Hi, I'm very interested helping you converting your database, I have more then 7 years of experience in SQL and database administration, modeling, optimizing and manipulating, please do not hesitate to check my portfol More

$200 USD in 3 days
(20 Reviews)

Hi, First of all thanks for posting such a project. I am oracle certified developer and dba with more than 5 years of experience. I am expert in SQL, PL/SQL. I did lots of oracle project in freelancer. http://ww More

$166 USD in 3 days
(17 Reviews)

schmozza Hi! I can comlete your job. There are several completed projects in Oracle SQL, PL/SQL. You can find them in my profile. I can write for you script for SQL Tool (like SQL Navigator, Toad) or SQLPlus. More

$133 USD in 3 days
(21 Reviews)

Hi I have more than 10 years experience in Oracle database design and administration. Please see my profile. Thanks

$155 USD in 3 days
(16 Reviews)

A proposal has not yet been provided

$88 USD in 3 days
(1 Review)

schmozza I am experienced Oracle DB administrator with more than 14 years of experience. Accept my proposal and you will not complain.

$111 USD in 7 days
(0 Reviews)

Hey There ! I can do this for your. Let's discuss more on this. Looking forward to hear from you soon. Thanks.

$155 USD in 3 days
(0 Reviews)

First of all: schmozza I have 2y experience working with Oracle as a database administrator. After quiting I started on webdevelopment, but I've been always been responsible for the databases of the systems I worked More

$111 USD in 3 days
(0 Reviews)

The requested task (schmozza) can be done with PL/SQL and Unix bash scripting. But the best approach will be bash scripting. There is not need to provide a whole dump of data . you can only provide table structures wh More

$155 USD in 3 days
(0 Reviews)

I understood that your scope is to reduce the redundent data. So please send me dump to verify. Method: 1. create master table with site column to connect each table. 2. Create backup table for storage 3. remov More

$222 USD in 7 days
(0 Reviews)

A proposal has not yet been provided

$155 USD in 5 days
(0 Reviews)

I can convert your all tables to one table using some flags. I have more than 12 years experience in Oracle Development.

$100 USD in 3 days
(0 Reviews)

As your information, If you have one site can connect to all site. we can get data directly by PL/SQL or SQL Loader to import data to target table or using Materialized View. If not, we need to discuss How to load More

$166 USD in 4 days
(0 Reviews)