• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 199
  • Last Modified:

data fix

How can we perform data fix in an oracle dba job.
0
jeevan mathew
Asked:
jeevan mathew
1 Solution
 
slightwv (䄆 Netminder) Commented:
Can you provide more information about what you are trying to do?

If I had to guess:  Fix from data and schedule it to run after hours.

If so:
Create a pl/sql script that does the fix and use dbms_scheduler with the job_type of plsql_block:
http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_sched.htm#ARPLS72235

There are tons of examples out there.
0
 
jeevan mathewdbaAuthor Commented:
Yes, this is good.
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now