Re: ALTER TABLE question
Date: Mon, 26 May 2008 13:07:23 -0700
> 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
> If I was to create my new structure table and cluster, I would use the
> create cluster testcluster(no1 number,no2 number,no3 number) size 300
> create table testtable(no1 number,no2 number,no3 number) cluster
> 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.
I know of no way to do it.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Mon May 26 2008 - 15:07:23 CDT