On Thu, Dec 13, 2018 at 7:26 AM soumitra bhandary <soumitra.bhandary@xxxxxxxxxxx> wrote:
But this one is third party application and dump is restored from dump file not plain text file . So is there any way to control it ?
Your backup file (and the source database is comes from) is corrupted.
You need to decide whether you want to restore that backup anyway; or just throw it away, fix the source database, and generate a new backup file.
If you want to do the former you will want to restore schema only. Modify the schema by dropping the foreign key. Restore the data. Fix the newly restored data. Recreate the foreign key.
David J.
