Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I wonder how it's possible to lose in database about 80% of foreign keys?

We had development and test databases in parallel.

Now I have found that diff of the schemas shows that FK's are not there. So is it possible to track down what happened with them? I've tried to get change history, but ARCHIVLOG was disabled.

share|improve this question
I don't think you can get that information because Oracle doesn't keep such a history. –  a_horse_with_no_name Jun 10 '13 at 14:57
add comment

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.