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

Home -> Community -> Usenet -> c.d.o.misc -> Move online vs online redef

Move online vs online redef

From: Oradba_Linux <techiey2k3_at_comcast.net>
Date: Tue, 24 May 2005 22:44:51 -0400
Message-ID: <LP2dneZIqLHHew7fRVn-gg@comcast.com>


We have used online redef extensively to convert to partitioned table from non-partitioned table.
What factors to consider before deciding whether to use move online or redef online for moving many tables to different tablespaces from one tablespace. tables are of varying sizes and varying activity level. I am going in favor of moving online so that i dont have to worry about triggers and grants.

We are oracle 9i / Redhat Linux. Received on Tue May 24 2005 - 21:44:51 CDT

Original text of this message

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