Re: inserts during table move
Date: Fri, 26 Oct 2001 15:23:36 -0400
Message-ID: <9rcd4u$blh$1_at_bob.news.rcn.net>
You are not completely right. For example, Oracle 8i supports DML for online index rebuild and table partitioins modifications which is DDL (ALTER...).
Eugene
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:ttjdh418c3t2c6_at_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 - 21:23:36 CEST