While I was preparing my database migration script for my project to satisfy specific version requirements, and as usual test it against database before submitting it to QA team. I got the following error with each "CREATE TRIGGER":
It was a very strange behaviour for me, and I contacted my DB team to get help, and logged a support on Oracle Metalink. Because it always works previously on 10g but my new environment is 11g.
It is a bug in oracle 11.2.0.2g and there are bugs logged for this issue:
Workaround:
At the beginning of my script, I have added the following alter line:
And at the end of the script add the following alter:
It was a very strange behaviour for me, and I contacted my DB team to get help, and logged a support on Oracle Metalink. Because it always works previously on 10g but my new environment is 11g.
It is a bug in oracle 11.2.0.2g and there are bugs logged for this issue:
- Bug 10174125
- Bug 10094416 is fixed in 12.1 release.
Workaround:
At the beginning of my script, I have added the following alter line:
And at the end of the script add the following alter:
No comments :
Post a Comment