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

$30-250 USD

クローズ

投稿日:

約10年前

$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.

Database Administration

Oracle

プロジェクト ID: 5551583

プロジェクトについて

12個の提案

リモートプロジェクト

アクティブ 10年前

お金を稼ぎたいですか？

メールアドレス

Freelancerで入札する利点

予算と期間を設定してください

仕事で報酬を得る

提案をご説明ください

登録して仕事に入札するのは無料です

この仕事に12人のフリーランサーが、平均$147 USDで入札しています

@Reza2012

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

$155 USD 3日以内

4.9

(30 レビュー)

4.9

@smshafiqulislam

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://www.freelancer.com/u/nibiranijum.html Did same type of works many times I am confident on delivering quality. If you wish, I can show you my existing projects. Rgds, Shafiq

$166 USD 3日以内

4.9

(23 レビュー)

5.1

@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 portfolio, there is some samples of databases modeling and database assignments. I've checked your requirement I can do this job in the deadline without a problem using SQL/PLSQL, because I've done many projects like this. Please send me all other details if you have about your project, so we can start asap. I'm available, and can start immediately. Looking forward to working with you. Thank you for your consideration. Regards

$200 USD 3日以内

4.5

(26 レビュー)

5.2

@jlsproject

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. Best regards, Denis.

$133 USD 3日以内

5.0

(20 レビュー)

4.4

@jkalivijay

A proposal has not yet been provided

$88 USD 3日以内

5.0

(8 レビュー)

3.1

@modestasmockus

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

$111 USD 7日以内

0.0

(0 レビュー)

0.0

@leoaj89

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 on. My plan is to create a stored procedure to perform the task so if the idea is to run this script regularly, we can schedule it on Oracle's scheduler without the need of 3rd part scripts. Kind regards, Leonardo.

$111 USD 3日以内

0.0

(0 レビュー)

0.0

@rizwanislam

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 which you can extract by export commadn with data=n option. With the help of bash scripting we can generate a log file to check the operational consistancy of required task.

$155 USD 3日以内

0.0

(0 レビュー)

0.0

@kapranav

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. remove reduent data from all table. 4. Make it regularize and prepare DML script 5. Create DDL script to insert exist data

$222 USD 7日以内

0.0

(0 レビュー)

0.0

@tiagofelicio

A proposal has not yet been provided

$155 USD 5日以内

0.0

(0 レビュー)

0.0

@SajidDeveloper

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

$100 USD 3日以内

0.0

(0 レビュー)

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. If not, we need to discuss How to load data from source to target site? before design and develop as your request later. I have experiences about migration and integration data with PL/SQL from many source to one target as your project. If you have any questions, please let me know and I hope we will work together.

$166 USD 4日以内