Re: Create table for append only

From: DA Morgan <>
Date: Mon, 26 May 2008 13:10:26 -0700
Message-ID: <>

Andrea wrote:

> My version of oracle DB is 10g R3...

There is no such thing as 10g R3. Do you mean

... and there are four primary key on 40 columns,

No there aren't there can only be one primary key on any table. Do you mean the primary key consists of 4 columns? If so, 4 out of 40, I wouldn't be heading toward an IOT.

> Does IOT table add complexity on manage database?


But you still have not indicated how it will be accessed. My suggestion would be to try it both ways and test.

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Mon May 26 2008 - 15:10:26 CDT

Original text of this message