Hi marc-olivierm,

we moved all our tables (except those with 'LONG' columns) to locally
managed tablespaces, not running into any problem.

If you are afraid, you could still copy the table from a to b, delete a
and rename b to a.

regards,

achim





"marc-olivier" <oracledba-ezmlmshield-x93833674.[Email address protected]
03.11.2005 09:46

An: "LazyDBA Discussion" <[Email address protected]
Kopie:
Thema: 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



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html



Oracle LazyDBA home page