Alter table move

Alter table move

 

  

Hi,

I'd like to know if an Alter table move can cause unavailability on a
database.
What if i move a table on another tablespace ?
Can you confirm this command will remove fragmentation on my tables (yes
i'm still using dictionnary managed tablespaces...)
Do you know if migrating from a dictionnay managed tablespace to a
localy managed tablespace can cause unavailability ?

Thanks for your help :))

--
Marc-Olivier Meunier


Oracle LazyDBA home page