Re: alter table move

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Fri, 6 Apr 2007 13:29:45 +0200
Message-ID: <486b2b610704060429o3ce57b38p41212fd8257c92b0@mail.gmail.com>

You might want to take a look at dbms_redefinition instead

Stefan

On 4/5/07, fmhabash_at_gmail.com <fmhabash_at_gmail.com> wrote:
>
> I have done some research on this feature and would like to have other
> DBAs shed light on its real-life usage...
>
> - this statement will require a lock for the entire operation of the
> move. If not, please explain how?
> - even though, there is an 'online' keyword, but it can only be used on
> IOTs not heap tables.
> - It will keep the indexes on the new table but will make them unusable.
> - stats will be invalidated as well.
> - I would like to know how does Oracle do the move internally and how
> it impacts user transactions? Could not find this information anywhere.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
=========================

Stefan P Knecht
Consultant
Infrastructure Managed Services

Trivadis AG
Europa-Strasse 5
CH-8152 Glattbrugg

Phone +41-44-808 70 20
Fax +41-808 70 12
Mobile +41-79-571 36 27
stefan.knecht_at_trivadis.com
http://www.trivadis.com

=========================

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Apr 06 2007 - 06:29:45 CDT