Re: equivalent of 'clustered' (SQL) in ORACLE

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 16 Jan 2001 22:06:59 -0800
Message-ID: <3A653683.57788EA7@exesolutions.com>

> This is what I have written in SQL:
>
> create table TEST
> (ID int primary key clustered,
> name varchar(30),
> .....etc)
>
> i am unsure of what "clustered" does and how to duplicate its effect
> within an oracle DB

I haven't a clue why you are using "clustered" at all. I suspect you don't either. So drop it.

It is best practice with Oracle to build tables without constraints but always specifying tablespace and storage clause.

Then use ALTER TABLE to add a named primary key constraint (w/wo) USING INDEX if an index is required.

Oracle has literally hundreds of options for building tables, constraints, and indexes of which 99% of the time you will have absolutely no need of them and they are best understood and ignored.

Daniel A. Morgan Received on Wed Jan 17 2001 - 00:06:59 CST