RE: Buffer gets
- From: "Chitale, Hemant Krishnarao" <Hemant.Chitale@xxxxxx>
- To: <joe_dba@xxxxxxxxxxx>
- Date: Thu, 21 Apr 2011 11:03:49 +0800
See
http://download.oracle.com/docs/cd/E11882_01/server.112/e16579/constra.h
tm#i1006394
FOREIGN KEY Constraints in a Data Warehouse
".............................
..............................
..............................
ENABLE NOVALIDATE can quickly create an enforced constraint, even when
the constraint is believed to be true. Suppose that the ETL process
verifies that a FOREIGN KEY constraint is true. Rather than have the
database re-verify this FOREIGN KEY constraint, which would require time
and database resources, the data warehouse administrator could instead
create a FOREIGN KEY constraint using ENABLE NOVALIDATE."
Hemant K Chitale
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Hemant K Chitale
Sent: Thursday, April 21, 2011 9:02 AM
To: joe_dba@xxxxxxxxxxx
Cc: c
Subject: Re: Buffer gets
You could ENABLE .... NOVALIDATE if you are 100% sure that the data was
validared during ETL.
This is somewhere in the Datawarehousing Guide in the documentation.
Hemant K Chitale
sent from my smartphone
On 21 Apr 2011 03:04, "Joe Smith" <joe_dba@xxxxxxxxxxx> wrote:
> After a direct path load. Enable FK cons with:
>
> Alter table enable con con_name exceptions into exceptions table
>
>
> Thanks
>
This email and any attachments are confidential and may also be privileged. If
you are not the addressee, do not disclose, copy, circulate or in any other way
use or rely on the information contained in this email or any attachments. If
received in error, notify the sender immediately and delete this email and any
attachments from your system. Emails cannot be guaranteed to be secure or
error free as the message and any attachments could be intercepted, corrupted,
lost, delayed, incomplete or amended. Standard Chartered PLC and its
subsidiaries do not accept liability for damage caused by this email or any
attachments and may monitor email traffic.
Standard Chartered PLC is incorporated in England with limited liability under
company number 966425 and has its registered office at 1 Aldermanbury Square,
London, EC2V 7SB.
Standard Chartered Bank ("SCB") is incorporated in England with limited
liability by Royal Charter 1853, under reference ZC18. The Principal Office of
SCB is situated in England at 1 Aldermanbury Square, London EC2V 7SB. In the
United Kingdom, SCB is authorised and regulated by the Financial Services
Authority under FSA register number 114276.
If you are receiving this email from SCB outside the UK, please click
http://www.standardchartered.com/global/email_disclaimer.html to refer to the
information on other jurisdictions.
Other related posts:
