Hi
We have a package that has about 30 DataPump Tasks. We use this package to load the data from a temporary database to a production database. Since the load is into a prodn database, the tables have to be loaded in a sequece. So, we have precedence constraints defined for each task so that if the previous task fails, we do not load the subsequent tables

It so happens that the first 10 tables have been loaded successfully. But there is an issue with the 16th table. So, the package fails. We then look at the error and then manually load the data for remaining tables (by executing each task manually). We would like to automate this process

So, at the beginning itself, the user enters the task num from which the load should happen. Based on this input the package should execute the tasks. For eg. the user enters 3. This means that the first 2 tasks should not be executed (since the data for these tables is already loaded in the previous run)

Would really appreciate if someone can give me some pointers to how this can be done

I have tried to do some disabling etc. but it is not working

Thank
Raja