Re: Question about adding a column to a partitioned table

From: Jan Nowitzky <nowitzky_at_informatik.uni-jena.de>
Date: Wed, 10 Mar 1999 12:45:18 +0100
Message-ID: <36E65B4E.1552BDCE@informatik.uni-jena.de>

Hi,

of course yuo can add a column to a partitioned table like you add a column to a non-partitioned table. You cannot change the so called partition-key. Hope it helps,
Jan

Prabhakar wrote:

> I have a question about partitioned table,If I partition a table at the
> creation and later on I want to add a column to the table,do I have
> to do it like I do for a non partitioned table or do I have to
> delete and recreate the partition....
>
> Please do give me an answer for this...
>
> Thanks in Advance
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Mar 10 1999 - 05:45:18 CST