Re: Move table and index rebuild in STD edition

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 20 Sep 2004 12:56:28 -0700
Message-ID: <2687bb95.0409201156.49c49c9d@posting.google.com>

"G Dahler" <gordon.dalher_at_spamex.com> wrote in message news:<I2B3d.7992$bL1.341425_at_news20.bellglobal.com>...
> We are using oracle 8i std edition (moving to 9i or 10g soon)
>
> With regards to the move table and index rebuild command, and being in the
> standard edition, I wonder what happens in terms of locking when I move a
> table or rebuild an index (in order to change it's tablespace) in oracle std
> edition.
>
> In enterprise edition, I know there is an "online move and rebuild option"
>
> In standard edition, what happens ? The table or index is locked and all
> transactions are waiting on the lock until the table is moved or the index
> rebuilt ?
>
> I can't seem to find the answer in the docs.

Yes, in the standard or Enterprise edition if you do a normal (non-online) table move or index rebuild DML activity is blocked and will wait for the DDL completion.

HTH -- Mark D Powell -- Received on Mon Sep 20 2004 - 14:56:28 CDT