-
Re: Indexed Organized Tables
Mladen Gogala wrote:
> 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.
Heck in Texas they seem to be willing to execute you just for not being
the flavour of the month.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)
-
Re: Indexed Organized Tables
>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.
Hmmm, so _that's_ why I haven't gotten the Florida Oracle support team
lately.
jg
--
@home.com is bogus.
"Don Henley must die." - Mojo Nixon
http://www.signonsandiego.com/news/b.../index.html#th
-
Re: Indexed Organized Tables
>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.
Hmmm, so _that's_ why I haven't gotten the Florida Oracle support team
lately.
jg
--
@home.com is bogus.
"Don Henley must die." - Mojo Nixon
http://www.signonsandiego.com/news/b.../index.html#th
-
Re: Indexed Organized Tables
>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.
Hmmm, so _that's_ why I haven't gotten the Florida Oracle support team
lately.
jg
--
@home.com is bogus.
"Don Henley must die." - Mojo Nixon
http://www.signonsandiego.com/news/b.../index.html#th
-
Re: Indexed Organized Tables
>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.
Hmmm, so _that's_ why I haven't gotten the Florida Oracle support team
lately.
jg
--
@home.com is bogus.
"Don Henley must die." - Mojo Nixon
http://www.signonsandiego.com/news/b.../index.html#th
-
Re: Indexed Organized Tables
>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.
Hmmm, so _that's_ why I haven't gotten the Florida Oracle support team
lately.
jg
--
@home.com is bogus.
"Don Henley must die." - Mojo Nixon
http://www.signonsandiego.com/news/b.../index.html#th
-
Re: Indexed Organized Tables
>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.
Hmmm, so _that's_ why I haven't gotten the Florida Oracle support team
lately.
jg
--
@home.com is bogus.
"Don Henley must die." - Mojo Nixon
http://www.signonsandiego.com/news/b.../index.html#th
-
Re: Indexed Organized Tables
>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.
Hmmm, so _that's_ why I haven't gotten the Florida Oracle support team
lately.
jg
--
@home.com is bogus.
"Don Henley must die." - Mojo Nixon
http://www.signonsandiego.com/news/b.../index.html#th
