Re: Is there a way to add a new column to a table while the table is being used for queries???

From: Harry Tuttle <>
Date: Fri, 13 Jan 2012 08:59:11 +0100
Message-ID: <>, 12.01.2012 21:01:
> I require the ability to add a new clob field to a database table
> object on Oracle 10g SQL server.
> Can I just do an
> alter table MyTable add column mynewfield clob;
> How do I insure that users can continue to make queries on the
> table???
> I would be greatful if someone could point me to some documentation on
> this subject of high availability in a huge partitioned data warehouse
> type environment.

I think that's what dbms_redefinition is supposed to solve. Received on Fri Jan 13 2012 - 01:59:11 CST

Original text of this message