Received: (qmail 11193 invoked from network); 21 Apr 2011 03:15:28 -0500
Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180)
by static-ip-85-25-126-90.inaddr.intergenia.de with SMTP; 21 Apr 2011 03:14:36 -0500
Received: from localhost (localhost [127.0.0.1])
by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A1415E08BAA;
Thu, 21 Apr 2011 04:13:46 -0400 (EDT)
DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org;
s=turing; t=1303373626; bh=WfjxzfhtukACaPVe8OWKoCXk/cgxpaIkiTe7jaDy
kos=; h=From:To:Date:Subject:Message-ID:References:In-Reply-To:
Content-Type:MIME-Version:Sender:Reply-To:List-help:
List-unsubscribe:List-Id:List-subscribe:List-owner:List-post:
List-archive; b=cQf9SarZYUjF8EaNJWqeVp0peFZvm4SnvTu059lIjBl9Nm7v7O
YblwHydPBw8H7f/qRGRMloly+FiraF8dMvsbMuZ62HifHfBhn813lOC9uzcofLfJhHD
IFLZ6/MV+DFLpzrRhHhVYCFg53szSwP+6h5CTKED3UgBREQtxJ/p3E=
X-Virus-Scanned: Debian amavisd-new at localhost.localdomain
Received: from turing.freelists.org ([127.0.0.1])
by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024)
with ESMTP id QLLv2R+o45dK; Thu, 21 Apr 2011 04:13:46 -0400 (EDT)
Received: from turing.freelists.org (localhost [127.0.0.1])
by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D4EF8E084DF;
Thu, 21 Apr 2011 04:13:02 -0400 (EDT)
Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 21 Apr 2011 04:12:21 -0400 (EDT)
Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A5841E07DAF for ; Thu, 21 Apr 2011 04:12:20 -0400 (EDT)
Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id pyQRuNJpoM-7 for ; Thu, 21 Apr 2011 04:12:20 -0400 (EDT)
Received: from mail92.messagelabs.com (mail92.messagelabs.com [194.106.220.51]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8553BE07C28 for ; Thu, 21 Apr 2011 04:12:18 -0400 (EDT)
X-VirusChecked: Checked
X-Env-Sender: Dominic.Brooks@barclayscapital.com
X-Msg-Ref: server-12.tower-92.messagelabs.com!1303373537!21365959!1
X-StarScan-Version: 6.2.9; banners=-,-,-
X-Originating-IP: [141.228.106.171]
Received: (qmail 30757 invoked from network); 21 Apr 2011 08:12:17 -0000
Received: from bcmh.barcap.com (HELO mx32.barcap.com) (141.228.106.171) by server-12.tower-92.messagelabs.com with DHE-RSA-AES256-SHA encrypted SMTP; 21 Apr 2011 08:12:17 -0000
Received: from ldnpsmeg0000003.INTRANET.BARCAPINT.COM (ldnpsmeg0000003.sgp.mess.barcap.com [10.76.206.223]) by mx32.barcap.com (Postfix) with ESMTP id 8E3B8D0001; Thu, 21 Apr 2011 09:12:17 +0100 (BST)
Received: from ldnpsmmgch03.INTRANET.BARCAPINT.COM (Not Verified[10.74.76.8]) by ldnpsmeg0000003.INTRANET.BARCAPINT.COM with Barclays Capital Filter ESMTP id ; Thu, 21 Apr 2011 09:12:17 +0100
Received: from LDNPCMMGMB11.INTRANET.BARCAPINT.COM ([169.254.1.216]) by ldnpsmmgch03.INTRANET.BARCAPINT.COM ([10.74.76.8]) with mapi; Thu, 21 Apr 2011 09:12:17 +0100
From:
To: , ,
Date: Thu, 21 Apr 2011 09:12:17 +0100
Subject: RE: Buffer gets
Thread-Topic: Buffer gets
Message-ID: <853BE8E3785A554D92010F1FB6C0B279AE3E9E1D@LDNPCMMGMB11.INTRANET.BARCAPINT.COM>
References: <8D8B0B559331204097D63ABDAC32FCA180B136@HKMGAXMB107A.zone1.scb.net>
In-Reply-To: <8D8B0B559331204097D63ABDAC32FCA180B136@HKMGAXMB107A.zone1.scb.net>
Accept-Language: en-US, en-GB
Content-Language: en-US
X-MS-Has-Attach:
X-MS-TNEF-Correlator:
acceptlanguage: en-US, en-GB
Content-Type: multipart/alternative; boundary="_000_853BE8E3785A554D92010F1FB6C0B279AE3E9E1DLDNPCMMGMB11INT_"
MIME-Version: 1.0
X-archive-position: 35898
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
X-original-sender: Dominic.Brooks@barclayscapital.com
Precedence: normal
Reply-To: Dominic.Brooks@barclayscapital.com
List-help:
List-unsubscribe:
List-software: Ecartis version 1.0.0
List-Id: oracle-l
X-List-ID: oracle-l
List-subscribe:
List-owner:
List-post:
List-archive:
X-list: oracle-l
--_000_853BE8E3785A554D92010F1FB6C0B279AE3E9E1DLDNPCMMGMB11INT_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
And RELY of course, if appropriate, for the optimizer's benefit.
________________________________
From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org=
] On Behalf Of Chitale, Hemant Krishnarao
Sent: 21 April 2011 04:04
To: joe_dba@hotmail.com
Cc: oracle-l@freelists.org
Subject: RE: Buffer gets
See http://download.oracle.com/docs/cd/E11882_01/server.112/e16579/constr=
a.htm#i1006394
FOREIGN KEY Constraints in a Data Warehouse
".............................
..............................
..............................
ENABLE NOVALIDATE can quickly create an enforced constraint, even when th=
e constraint is believed to be true. Suppose that the ETL process verifie=
s that a FOREIGN KEY constraint is true. Rather than have the database re=
-verify this FOREIGN KEY constraint, which would require time and databas=
e resources, the data warehouse administrator could instead create a FORE=
IGN KEY constraint using ENABLE NOVALIDATE."
Hemant K Chitale
________________________________
From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org=
] On Behalf Of Hemant K Chitale
Sent: Thursday, April 21, 2011 9:02 AM
To: joe_dba@hotmail.com
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" > 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 privilege=
d. 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 a=
ny attachments. If received in error, notify the sender immediately and =
delete this email and any attachments from your system. Emails cannot be=
=20guaranteed to be secure or error free as the message and any attachmen=
ts could be intercepted, corrupted, lost, delayed, incomplete or amended.=
=20 Standard Chartered PLC and its subsidiaries do not accept liability f=
or damage caused by this email or any attachments and may monitor email t=
raffic.
Standard Chartered PLC is incorporated in England with limited liability =
under company number 966425 and has its registered office at 1 Aldermanbu=
ry Square, London, EC2V 7SB.
Standard Chartered Bank ("SCB") is incorporated in England with limited l=
iability by Royal Charter 1853, under reference ZC18. The Principal Offi=
ce of SCB is situated in England at 1 Aldermanbury Square, London EC2V 7S=
B. In the United Kingdom, SCB is authorised and regulated by the Financia=
l Services Authority under FSA register number 114276.
If you are receiving this email from SCB outside the UK, please click htt=
p://www.standardchartered.com/global/email_disclaimer.html to refer to th=
e information on other jurisdictions.
_______________________________________________
This e-mail may contain information that is confidential, privileged or o=
therwise protected from disclosure. If you are not an intended recipient =
of this e-mail, do not duplicate or redistribute it by any means. Please =
delete it and any attachments and notify the sender that you have receive=
d it in error. Unless specifically indicated, this e-mail is not an offer=
=20to buy or sell or a solicitation to buy or sell any securities, invest=
ment products or other financial product or service, an official confirma=
tion of any transaction, or an official statement of Barclays. Any views =
or opinions presented are solely those of the author and do not necessari=
ly represent those of Barclays. This e-mail is subject to terms available=
=20at the following link: www.barcap.com/emaildisclaimer. By messaging wi=
th Barclays you consent to the foregoing. Barclays Capital is the invest=
ment banking division of Barclays Bank PLC, a company registered in Engla=
nd (number 1026167) with its registered office at 1 Churchill Place, Lond=
on, E14 5HP. This email may relate to or be sent from other members of t=
he Barclays Group.
_______________________________________________
--_000_853BE8E3785A554D92010F1FB6C0B279AE3E9E1DLDNPCMMGMB11INT_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
And RELY of course, if appropriate, =
for
the optimizer’s benefit.
From:
oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] <=
span
style=3D'font-weight:bold'>On Behalf Of Chitale, Hemant Krishn=
arao
Sent: 21 April 2011 04:04<=
br>
To: joe_dba@hotmail.com
Cc: oracle-l@freelists.org=
Subject: RE: Buffer gets=
span>
=
See http://download.oracle.com/docs/cd/E11882_01/server.1=
12/e16579/constra.htm#i1006394
=
FOREIGN KEY Const=
raints
in a Data Warehouse
=
"…R=
30;…………………..<=
/font>
……=
230;…………………=
font>
……=
230;…………………=
font>
ENABLE NOVALIDATE=
=20can
quickly create an enforced constraint, even when the constraint is believ=
ed to
be true. Suppose that the ETL process verifies that a FOREIGN KEY constra=
int 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."
=
From:
oracle-l-bounce@freelists.org
[mailto:oracle-l-bounce@freelists.org]
On Behalf Of Hemant K Chit=
ale
Sent: Thursday, April 21, =
2011
9:02 AM
To: joe_dba@hotmail.com
Cc: c
Subject: Re: Buffer gets=
span>
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" &l=
t;joe_dba@hotmail.com> wrote:
> After a direct path load. Enable FK cons with:
>
> Alter table enable con con_name exceptions into exceptions table
=
>
>
> Thanks
>
_______________________________________________<=
?xml:namespace=20
prefix =3D o ns =3D "urn:schemas-microsoft-com:office:office"=20
/>
This e-mail may =
contain=20
information that is confidential, privileged or otherwise protected from =
disclosure. If you are not an intended recipient of this e-mail, do not=20
duplicate or redistribute it by any means. Please delete it and any attac=
hments=20
and notify the sender that you have received it in error. Unless specific=
ally=20
indicated, this e-mail is not an offer to buy or sell or a solicitation t=
o buy=20
or sell any securities, investment products or other financial product or=
=20
service, an official confirmation of any transaction, or an official stat=
ement=20
of Barclays. Any views or opinions presented are solely those of the auth=
or and=20
do not necessarily represent those of Barclays. This e-mail is subject to=
=20terms=20
available at the following link: www.barcap.com/emaildiscla=
imer.=20
By =
messaging=20
with Barclays you consent to the foregoing. Barclays Capital is the investm=
ent=20
banking division of Barclays Bank PLC, a company registered in England<=
/st1:place>=20
(number 1026167) with its registered office at 1 Churchill Place, London, E14=20
5HP.&nbs=
p;=20
This email may relate to or be sent from other members of the Barc=
lays=20
Group.
_______________________________________________<=
/FONT>
This email and any attachments are confidential and may also be priv=
ileged. If you are not the addressee, do not disclose, copy, circulate o=
r in any other way use or rely on the information contained in this email=
=20or any attachments. If received in error, notify the sender immediate=
ly and delete this email and any attachments from your system. Emails ca=
nnot be guaranteed to be secure or error free as the message and any atta=
chments could be intercepted, corrupted, lost, delayed, incomplete or ame=
nded. Standard Chartered PLC and its subsidiaries do not accept liabilit=
y for damage caused by this email or any attachments and may monitor emai=
l traffic.
=20
Standard Chartered PLC is incorporated in England with limited liability =
under company number 966425 and has its registered office at 1 Aldermanbu=
ry Square, London, EC2V 7SB.
=20
Standard Chartered Bank ("SCB") is incorporated in England with=
=20limited liability by Royal Charter 1853, under reference ZC18. The Pr=
incipal Office of SCB is situated in England at 1 Aldermanbury Square, Lo=
ndon EC2V 7SB. In the United Kingdom, SCB is authorised and regulated by =
the Financial Services Authority under FSA register number 114276.
=20
If you are receiving this email from SCB outside the UK, please click htt=
p://www.standardchartered.com/global/email_disclaimer.html to refer to th=
e information on other jurisdictions.
--_000_853BE8E3785A554D92010F1FB6C0B279AE3E9E1DLDNPCMMGMB11INT_--
--
http://www.freelists.org/webpage/oracle-l