RE: Create Primary Keys in Parallel
- From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
- To: <doodon@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 14 Feb 2005 11:58:07 +0100
Don, two comments:
once you have created a unique index in Oracle, declaring a primary key
becomes very fast and easy -- because Oracle will find the existing index
and use it to protect the primary key constraint.
you can also create/declare primary key constraints *without* enabling them
immediately, and then enable them in parallel.
So I think the book gives the wrong suggestion, for two reasons...
Lex.
----------------------------------------------------------------
Tom Kyte Seminar: http://www.naturaljoin.nl/events/seminars.html
----------------------------------------------------------------
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Don Doo
Sent: Monday, February 14, 2005 11:52
To: oracle-l@xxxxxxxxxxxxx
Subject: Create Primary Keys in Parallel
Hi,
Is it possible to create a primary key in parallel?. I happened to see a
book on Oracle data warehousing which recomments to create only unique
indexes (and no primary keys) in data warehouse. The author says Unique
indexes can be created in parallel and primary keys do not support parallel
creation. We are a non-Oracle shop building the first Oracle database and
this is going to be large reporting database in Oracle 9i. Please pardon me
if the question is too basic.
Regards,
Don
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
