Re: ALTER TABLE question

From: DA Morgan <>
Date: Mon, 26 May 2008 13:07:23 -0700
Message-ID: <> wrote:
> Hello, I need to alter a table by adding a column and adding this
> column to a cluster already on the table. I don't know how to do it.
> There is a section in the Oracle online documentation on altering
> clustered tables but it doesn't really help.
> I cannot find an example on Morgans library either.
> If I was to create my existing table I would use something like the
> following. I have simplified it considerably just to get my point
> across. The production implementation is far from this simple.
> create cluster testcluster(no1 number,no2 number) size 300 index;
> create table testtable(no1 number,no2 number) cluster
> testcluster(no1,no2);
> If I was to create my new structure table and cluster, I would use the
> following.
> create cluster testcluster(no1 number,no2 number,no3 number) size 300
> index;
> create table testtable(no1 number,no2 number,no3 number) cluster
> testcluster(no1,no2,no3);
> What I want to do is to MODIFY my existing table and cluster however
> so that they have the new structure.
> Can this be done and if so, how.
> This is my first post to this newsgroup and my apologies if I am being
> too direct in my request for help. Finally we are currently 11.1.0 on
> Solaris 10. Thank you for reading.
> Mark

I know of no way to do it.

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:07:23 CDT

Original text of this message