Auto dB data refresh from prod to dev using dump file specif to a month or day using partition table

₹600-1500 INR

Inaendelea

Imechapishwa

about 6 years ago

₹600-1500 INR

Kulipwa wakati wa kufikishwa

Plsql block which will do dB refresh automatically will be called using Unix script. Find all list of tables with *_bkp and export to a file, which will edited/removed (say some backup tables are being used by some developer for there testing, so once after list is exported and edited then below job will be start by different Unix script). 1. Schema based reference key disable 2. delete all partitions in tables and create new partitions for that day/month for data will be refreshed. 3. Truncate all tables. 4. Insert data from production dump files. 5. Enable all reference constarint. 6. With proper log and exception in all steps.

Linux

Oracle

Kitambulisho cha mradi: 16518929

Kuhusu mradi

5 mapendekezo

Mradi wa mbali

Inatumika 6 yrs ago

Unatafuta kupata pesa?

Barua pepe

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa

Pata malipo kwa kazi yako

Eleza pendekezo lako

Ni bure kujiandikisha na kutoa zabuni kwa kazi

Imetolewa kwa:

@tausy

₹10,000 INR ndani ya siku 4

5.0

(3 hakiki)

2.7

5 wafanyakazi huru wana zabuni kwa wastani ₹9,973 INR kwa kazi hii

@sathish2connect

Data processing from flat files with delimiter, loading into bkp table and then loading in main table. Failed records are loaded into bad files and log files to provide complete set of data processed

₹1,750 INR ndani ya siku 1

5.0

(1 hakiki)

1.4

@maverickindia

I am oracle certified. Let me know how can we work. I am always available on Email and Skype. Please have a voice or video chat if necessary. I will be available more than 40 hours per week and able to start your project as soon as possible according to you. Thank you for taking the time to read my application. I look forward to talking with you.

₹1,450 INR ndani ya siku 3

0.0

(0 hakiki)

0.0

@nubelo_8WZvqto5

I have about 3 years of experience with oracle databases, OCP 11g and 12c certification. Additionally I am working to automate works in databases standard edition.

₹25,555 INR ndani ya siku 15