Re: alter table move
- From: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
- To: fmhabash@xxxxxxxxx
- Date: Fri, 6 Apr 2007 13:29:45 +0200
You might want to take a look at dbms_redefinition instead
Stefan
On 4/5/07, fmhabash@xxxxxxxxx <fmhabash@xxxxxxxxx> 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.
--
//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@xxxxxxxxxxxx
http://www.trivadis.com
=========================
Other related posts:
