Has anyone moved a Locally-managed tablespace from one instance to another. I have seen this stated in several books but none explain how exactly to do that. It makes complete sense since everything in the tablespace is self managed. One problem might be if the data is in one tablespace and the indexes in another.

Regards,
Eric