Changing to LMT tablespaces

All,

I'm planning on turning my dictionary managed tablespaces into locally managed tablespaces. Am I correct in assuming that I'll have to perform the following steps:

1. Create new tablespaces
2. Move tables into the new tablespaces
3. Since most of my tables are partitioned, I'll actually have to move each partition, right?
4. Rebuild indices into the new tablespaces
5. Drop the old tablespaces

Or is there an easier way?

Thanks,

Diana Duncan
Database Architect
filefrenzy
diana_at_filefrenzy.com
919.760.1151 <-- New number Received on Tue Oct 24 2000 - 15:53:06 CDT