Re: inserts during table move

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 26 Oct 2001 20:14:31 +0200
Message-ID: <ttjdh418c3t2c6@corp.supernews.com>

"Eugene" <efiryago_at_netivitysolutions.com> wrote in message news:9rc8l6$nls$1_at_bob.news.rcn.net...
> Does Oracle support inserts into a_table during 'ALTER TABLE a_table MOVE
> TABLESPACE a_new_tbs' operation?
>
> Thanks,
> Eugene
>
>
>

any ALTER TABLE is a DDL operation, during which the table is locked. This means you will get ora-0054, resource busy and acquire with nowait specified and can't do anything to your table. Try to imagine what is going to happen if Oracle would allow concurrent access during such operations.

Hth,

Sybrand Bakker
Senior Oracle DBA Received on Fri Oct 26 2001 - 13:14:31 CDT