Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Move online vs online redef
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
![]() |
![]() |