RE: Create Primary Keys in Parallel

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Mon, 14 Feb 2005 11:58:07 +0100
Message-Id: <20050214105808.C31014D7108@ha-smtp3.tiscali.nl>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Don Doo
Sent: Monday, February 14, 2005 11:52
To: oracle-l_at_freelists.org
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
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Mon Feb 14 2005 - 06:00:58 CST