Re: Is there a way to add a new column to a table while the table is being used for queries???
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Fri, 13 Jan 2012 09:41:23 -0800 (PST)
Message-ID: <17510282.1180.1326476483821.JavaMail.geo-discussion-forums_at_vba7>
If there are no long running queries then the OP should be able to issue the alter table to add the lob column while the table is in use without having to resort to running dbms_redefinition.
Date: Fri, 13 Jan 2012 09:41:23 -0800 (PST)
Message-ID: <17510282.1180.1326476483821.JavaMail.geo-discussion-forums_at_vba7>
If there are no long running queries then the OP should be able to issue the alter table to add the lob column while the table is in use without having to resort to running dbms_redefinition.
I would be more worried about developers who coded select * but then again under our rules select * is not allowed and any resulting error would be a developer issue. After all the request to modify the table structure should have come from a developer and been approved by the developer management chain.
HTH -- Mark D Powell -- Received on Fri Jan 13 2012 - 11:41:23 CST