I am trying to move a 1 TB table from one tablespace to another tablespace to remove fragmentation
alter table test move TABLESPACE test_tb nologging parallel 6;
For this how much temp ,Undo tablespace sizes I need to maintain .. Could you please help me on this . Also please
tell us know is there any performance related things I can do over here .
Do I need to gather stats once the activity was done ?
DB was in restricted mode . Before doing this activity do I need to enable row moment ?
Approximately how much time it will take for a table of size 1 TB to migrate from one table space to another table space .