Re: Is there a way to add a new column to a table while the table is being used for queries???
From: Harry Tuttle <OTPXDAJCSJVU_at_spammotel.com>
Date: Fri, 13 Jan 2012 08:59:11 +0100
Message-ID: <9na6g9Fe69U1_at_mid.individual.net>
jack_gold2_at_yahoo.com, 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.
>
Date: Fri, 13 Jan 2012 08:59:11 +0100
Message-ID: <9na6g9Fe69U1_at_mid.individual.net>
jack_gold2_at_yahoo.com, 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.
http://docs.oracle.com/cd/B19306_01/server.102/b14231/tables.htm#ADMIN01514 http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_redefi.htm Received on Fri Jan 13 2012 - 01:59:11 CST