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

Closed

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

Project ID: #5551569

11 freelancers are bidding on average $238 for this job

elboukharimu

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
(19 Reviews)
4.9
mouchakraborty

A proposal has not yet been provided

$155 USD in 3 days
(0 Reviews)
0.0
gurkamalbajwa

Hi Schmozza, First few lines about me and my experience. • I am a result oriented professional with 12.5 years of experience in Solution Architecture, Database Administration, Database Performance Improveme More

$155 USD in 3 days
(0 Reviews)
0.0
rbkendhuli

A proposal has not yet been provided

$150 USD in 3 days
(0 Reviews)
0.0
rudranjay12

schmozza , i would use PLSQL script for this , I need database dump for this. Please share all requirement in details with me.

$155 USD in 3 days
(0 Reviews)
0.0
taohiko

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. I have experiences about migration and i More

$166 USD in 4 days
(0 Reviews)
0.0
ikhavins

I'm an expert in Database like Oracle, Sybase, MySQL. I've performed all functions from Administration and Modeling to actual SQL coding including stored procedures, triggers, functions etc. I have participated in many More

$1055 USD in 10 days
(0 Reviews)
0.0
kumar589

Hi, As mentioned in your description here is the word 'schmozza'. Before taking this project I would like to know to few details about the database side. 1. How many duplicate tables are there. 2. It requires to a More

$155 USD in 3 days
(0 Reviews)
0.0
leelabhaskar

Having 8+ Years of Experience in Datawarehouse, SQL and PL/Sql Programming with Unix Shell Scripting. Delivered Critical Deliverable to the Clients like GE, Knape & Vogt,Deautsch Bank,BAe Systems,PGI etc.,

$120 USD in 2 days
(0 Reviews)
0.0
tetsa

schmozza. Hi Please let me know in which language do you want reun the script either Perl or Shell and let me know your expections. Thanks &Regards Subhash Tetarwal

$155 USD in 3 days
(0 Reviews)
0.0
demba

A proposal has not yet been provided

$155 USD in 3 days
(0 Reviews)
0.0