Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> alter table ... move

alter table ... move

From: Stephan Bressler <stephan.bressler_at_siemens.com>
Date: Thu, 13 Feb 2003 13:09:30 +0100
Message-ID: <b2g1r8$a9n$1@news.mch.sbs.de> 





Hi there,



I'm about to reorg some of the tables (and indexes) in our database
(9.0.1.3).



How about using the "alter table ... move" instead of exp/imp?



What I know so far is:


- affected tables are locked for dml (no problem)






But what about


- FK constraints (are they still in place after move)






Are there any other implications to take care of?



TIA



Stephan
Received on Thu Feb 13 2003 - 06:09:30 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US