dbTalk Databases Forums  

Move online vs online redef

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss Move online vs online redef in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Oradba_Linux
 
Posts: n/a

Default Move online vs online redef - 05-24-2005 , 09:44 PM






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.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.