Auto dB data refresh from prod to dev using dump file specif to a month or day using partition table
₹600-1500 INR
Thanh toán khi bàn giao
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.
ID dự án: #16518929
Về dự án
Được trao cho:
5 freelancer chào giá trung bình₹9973 cho công việc này
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
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 pro Thêm
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.