Re: Indexed Organized Tables

On Mon, 10 Jan 2005 12:17:52 -0600, Florian wrote:

> Sometimes multiple records are written at the same time (same second),
> so it is impossible for us to create a primary key on the x_timestamp
> field, since we might loose records that.

Oracle has the data type called TIMESTAMP, which actually goes down to nanosecond. Using that for a primary key is a bad idea.

>
> Yet, we don't want to add any of the other fields to the timestamp since
> that doesn't seem to be logical. We tried it and the performance wasn't
> that great it seems.

You can always have a generated primary key, by using sequences.

>
> Is there no way to create an indexed organized table without using a
> primary key??

Creating tables without primary keys is illegal in Georgia, Tennessee, South Carolina, Kentucky and Mississippi. In Wyoming, Texas, Florida and Alabama you can actually be executed for creating tables without primary key.

-- 
Bug, noun: Son of a glitch