Re: Is there a way to add a new column to a table while the table is being used for queries???
From: joel garry <joel-garry_at_home.com>
Date: Thu, 12 Jan 2012 14:17:45 -0800 (PST)
Message-ID: <6ebb9b24-6ea4-40cc-bb5b-7cf1cf0fd3c1_at_a8g2000pbi.googlegroups.com>
On Jan 12, 12:01 pm, jack_go..._at_yahoo.com wrote:
> 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.
>
> Thank you in advance!
Date: Thu, 12 Jan 2012 14:17:45 -0800 (PST)
Message-ID: <6ebb9b24-6ea4-40cc-bb5b-7cf1cf0fd3c1_at_a8g2000pbi.googlegroups.com>
On Jan 12, 12:01 pm, jack_go..._at_yahoo.com wrote:
> 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.
>
> Thank you in advance!
In addition to what David said, see
http://orainternals.wordpress.com/2009/01/08/lock-table-followed-by-ddl/
jg
-- _at_home.com is bogus. http://tapcis.master.com/texis/master/search/+/Top/Computers/Software/Databases/OracleReceived on Thu Jan 12 2012 - 16:17:45 CST