Manage Learn to apply best practices and optimize your operations.

Clarification: Problem when re-enabling referential integrity

In your response to the question regarding referential constraints on a data warehouse, you stated: "At times, we disable this during loading cycles, but they are always restored after a load is complete. However, if these constraints are not re-enabled to fail to re-enable, this is a clear indication that your load routines did not perform as expected."

I don't understand the phrase "...are not re-enabled to fail to re-enable...".

Can you provide an explanation of this phrase?

This was last published in December 2003

Dig Deeper on Oracle data warehousing

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.








  • How do I size a UPS unit?

    Your data center UPS sizing needs are dependent on a variety of factors. Develop configurations and determine the estimated UPS ...

  • How to enhance FTP server security

    If you still use FTP servers in your organization, use IP address whitelists, login restrictions and data encryption -- and just ...

  • 3 ways to approach cloud bursting

    With different cloud bursting techniques and tools from Amazon, Zerto, VMware and Oracle, admins can bolster cloud connections ...