If I have two seperate tablespaces DATA versus INDEX tablespace. There are some indexes using the DATA tablespace so I reuild those indexes to INDEX tablespaces.
One problem I've noticed though, is if the indexes get created originally in the DATA tablespace, even if you rebuild the index in another tablespace, you cannot reclaim that space easily. Anyone have any ideas on that issue?